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.
