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.