Requery Combo Box Between Subforms

[Nigel Davison]

MS2K, VBA Beginner Lvl.

I have two subforms, both with a many to one relationship to the main form.
The second subform (B) has combo boxes which are based on a query using data
from combo boxes on the first subform (A).
When I use the Requery command to update the combo box in subform B with
After Update or On Change on the combo box on subform A the requery doesn't
happen until I have changed two combo boxes on subform A. Obviously I would
like the requery to happen after just one change/update.
Probably something really simple but I can't see it, if you can help and
point me in the right direction that would be great.

thanks in advance

Nigel