Which Event property should I use to refresh subform data?

[David Newmarch]

I have a combo box on an Order Details subform which doesn't display the
correct drop-down list (for selecting subclients of the agent placing the
order) unless you hit F9 to refresh the data each time you go to a different
record on the Orders table. To avoid having to do that I assume I need to set
an Event property somewhere on either the parent form or the subform but I'm
confused as to which Event property that should be, and on which form.

I guess a macro (to requery the subform?) would then do the trick, but I'd
prefer entering the necessary VBA code if somebody could maybe also give me a
lead there.

I'd be very grateful for a bit of guidance here.

 

[Ofer Cohen]

Use the On Current event of the from to refresh the combo, write the code

Me.[ComboName].Requery

 

[David Newmarch]

Thanks very much Ofer. That's exactly what was needed.