Parameters in Queries

[Jdaw94]

How do I make it so when a query is opened a dialog pops up asking for an
input or Parameter??

 

[Marshall Barton]

How do I make it so when a query is opened a dialog pops up asking for an
input or Parameter??

Just use whatever you want to appear in the pop prompt as a
field name in the query. Eg. [Enter your name]

 

[John W. Vinson]

How do I make it so when a query is opened a dialog pops up asking for an
input or Parameter??

Put the desired prompt in square brackets:

[Enter last name:]

on the criteria line.

Better - you'll want to move to this eventually - is to use an unbound Form to
collect your parameters. The user would never open or even see the query. The
query's criteria would resemble

=[Forms]![YourFormName]![txtStartDate]

and you would have code (perhaps a command button) on the form to open a
Report or another Form based on the query.