J Jdaw94 Apr 17, 2010 #1 How do I make it so when a query is opened a dialog pops up asking for an input or Parameter??
J John W. Vinson Apr 17, 2010 #2 How do I make it so when a query is opened a dialog pops up asking for an input or Parameter?? Click to expand... 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] Click to expand... and you would have code (perhaps a command button) on the form to open a Report or another Form based on the query.
How do I make it so when a query is opened a dialog pops up asking for an input or Parameter?? Click to expand... 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] Click to expand... and you would have code (perhaps a command button) on the form to open a Report or another Form based on the query.
