Issue with using a form field as query criteria

[beililiu]

Hi everyone, I have a form called Purchase Order Form that has a field textbox called [SearchCustomer]. I have combo box on the same form that shows a list of customers based on what the user has input into the SearchCustomer field. The combo box runs a query on the Customers table using whatever the user has typed into SearchCustomer. However, every time I try to use the form, I get the Enter Parameter pop up window that is asking me for the SearchCustomer Criteria. This happenes even when I enter a name into SearchCustomer. It's as if the query doesn't see that field at all. Any thoughts?

[R_Badger]

Are you sure you have defined the control properly in the query?

It should be:

[Forms]![Purchase Order Form]![SearchCustomer]

[beililiu]

Hi, yes I have made sure that the control is properly defined. Interestingly, I just changed the Has Module property under Form Property from Yes to No and now I don't receive that issue anymore.

[RuralGuy]

...I just changed the Has Module property under Form Property from Yes to No and now I don't receive that issue anymore.

I hope you know that that is not a solution. Something else is going on.