I have developed a parameter query that I want to use in code and set it to a form's .RecordSource property. How can I take a value off a form and use it as the parameter in the query without the query's own 'enter parameter' dialog coming up? When I define the parameter in code the code's enter parameter screen comes up but a second screen belonging to the query also comes up. The query uses the value from its own 'enter parameter' input.

Thanks for your help.