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??
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.
 
You must log in or register to reply here.

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

Similar Threads

Parameter Query Won't Run 0
Parameter Queries in Crosstab Query 2
why my parameter query doesn't work? 0
Multiple Parameter Crosstab query filter by form 1
How to get a query to call the parameter form 4
Parameter Query 1
Parameter Query 3
Modify Parameter Query 1

Back
Top