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