Requery a combo box on a subform

[crmarrio]

Hi...

I've got a main form (containing field PERSON-CODE), with a subform, with a ComboBox on the sub.

The options in the combo box relate to an underlying query with PERSON-CODE as one of the criteria.

OK, everything is fine so far... apart from, when you move on to the next record, the options in the combo box do not change.

I therefore (think) I need to force a Requery of the options in the combo box on one of the main form's events, such as on OnChange. The alternative (possibly) might be to do the requery everytime the combo box has the focus???

Please could someone help - I get really confused using code where subforms as concerned!!!

 

[Mile-O]

If you get confused with subforms, you'll enjoy this .