Prompts from one parameter query appearing in all queries


G

Guest

I created one parameter query prompting to enter date range. When I created
another query with no parameters and started it, it also asked me for the
date range. How can I get rid of the prompts in the other query? I looked in
the Query-Parameters… and it’s empty, so I am really puzzles by where this
query gets these parameters.

Please help.
 
Ad

Advertisements

J

Joan Wild

Is the query prompting for dates, based on another query? Does the source
query have these parameters?
 
Ad

Advertisements

J

Jeff Boyce

Zoya

Is the second query based on the first query? That would be one way the
second query "inherits" the prompt.

Have you opened the second query in design view and clicked on Query |
Parameters in the menu? Are there any parameters "hard-coded" in the
Parameters window that pops up?

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

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 from Form 6
ACCESS - how do I apply a IIF = statement without parameter value prompt. The two column comparison is count 1
parameter queries and runtime 1
Query date Parameter Anomaly 4
how to pass a parameter to a query base of a query that is the base of a report 0
Parameter in query not taking the value 3
Report Query Parameters 2
Access Invalid bracketing of parameter name 1

Top