Prompt With Multiple Values

[BPlenge]

I have a query, and one of the fields has a prompt for user input. Is there a way for the prompt to take multiple values?

 

[boblarson]

I have a query, and one of the fields has a prompt for user input. Is there a way for the prompt to take multiple values?

Create a form to supply your criteria and either set the query to refer to the form or use VBA to dynamically build your WHERE clause. A

Also, you should display the query results in a form or report and not directly in a query so that you have more control over how it is displayed, and you have events so you can do things, including complex validation, etc.