Parameters in Queries

  • Thread starter Thread starter Jdaw94
  • Start date Start date
J

Jdaw94

How do I make it so when a query is opened a dialog pops up asking for an
input or Parameter??
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top