requery a combobox in a continuious form subform

[JWCrosby]

I a subform formatted in continuous forms. It's related to the main form in
a one-to-many relationship (i.e., the main/parent form has many records in
the subform).

One of the fields in the subform is a combo box based upon a query where you
assign a room to the record. When you move to the next record in the
subform, I need to requery that combo box to update the list of available
rooms.

I've tried a few things but haven't figured it out quite yet. Any help?

Thanks in advance!

Jerry

 

[JWCrosby]

I spoke too soon! I did a quick Google search and found the answer. I needed
to put the requery in the form's after update property.