Drop Down Combo Box Help?

[Adam]

I have a drop down combo box on my form with names and whenever you choose a
name in the list it displays record below (in the subform) for that chosen
name based on a customer ID that links the combo box to the records in the
subform below. However when i first open the form it displays one name but
the records of another (this only happens when form is first opened). How can
i make it so that the name in the drop down when the form opens also displays
records below that belong to the first or default name in the combo box??

 

[Ron2006]

How are you accomplishing that link?

If you have have the subform related to the combo as a master/child
relationship it should handle it properly.

if you are using a query with criteria pointing to the combo itself,
it believe this will also work but you may want to do a requery of the
subform in the oncurrent or onopen of the main form. I would be
surprised if this was the situation since you should already be
getting a query of the subform in the open process.

If you are using a query with criterian pointing to some other field
that is loaded when you select an employee name, then you need to
empty or do load of that field and a requery in the oncurrent or
onopen of the main form just as above. If you do not do this then the
query is pointing to the last ID that was loaded into that other field
while the combo is pointing somewhere else.

Ron