D
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.
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.