Need Help with Subform Combo Box!

[John Lane]

I have a subform on a form. The subform is a continuous form that has a combo
box. I manage the list of items that display in the combo box by removing
from the list all previous items that have been selected and stored in the
table when the users moves focus to the “*†(new/add) record. If the user
gives focus to a record that is populated I change the combo box query to the
entire list so all the items will be visible thru the combo box query. It
works great except when I click to the new record row, and then move the
mouse pointer in and out of the subform. It appears that the Access engine is
requerying or refreshing the subform. Now the combo box has the restricted
list, which does not contain any of the previously selected item, so all the
populated combo box items disappear because the query does not now contain
them. I can’t find the event that fires (if any) so I can jam back in the
query that contains the entries list so they will reappear. Anybody got any
idea on what event is firing when the mouse pointer moves back into the
subform? Thanks.

 

[Jeff L]

My guess would be either On Enter or On Current. The On Enter event
can only be seen through the main form. Double click on the Subform
itself and the properties window will pop up so you can view the
events, if any.