If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Requery Combo box in popup form
I have a form set-up as a popup in datasheet view with a combo box. The
combo box is used to assign a room to a student. I have a check box that is used when the student checks out. When I select the check box, it removes the students name from the table that provides the source for the combo box (amongst other things as well) via a macro on the after update event for the form. I then have the form's after update macro do a requery so when I go to a different record, the combo box will be updated. Unfortunately, the requery command does not work with the form set up as a popup. Is there another way I can make this work? Thanks for the help. |
#2
|
|||
|
|||
Requery Combo box in popup form
strange works for me what is the code you are using in your macro
Regards Kelvan |
#3
|
|||
|
|||
Requery Combo box in popup form
I am just using the Requery command in the macro with the control blank (the
Help states that it must be left blank for datasheet view, which I am using). |
Thread Tools | |
Display Modes | |
|
|