select current value on form in query

[HowsMusic]

I have a combo box that I want to populate with names based on a Customer ID. I want it to populate or update itself when a Customer ID is entered in the CustomerID field on the form. I have the Row Source of the combo box set to SELECT Users.[User ID], Users.[User Name], Users.CustomerID FROM Users WHERE Users.CustomerID=????(I want the question marks to point to the Customer ID field on the form);

I am basically a rookie in this stuff but am being pressured to make this work. Thanks in advance.

 

[Orion45]

I think what you need is:

[Forms]![MainFormName]![CustomerID]

hope this helps
Ryan

 

[HowsMusic]

Thanks...D'oh!