How do I disable 'Enter Parameter Value' prompt on an existing Que

[QuickQuestion]

I'm getting a pop up box when I try to open an exisitng, saved Query that
says "Enter Parameter Value" - I'm positive that that's a new thing, because
I've saved most of the Queries in there and never had to enter it before. How
can I disable that pop-up box?

 

[Jeff Boyce]

That pop-up pops up because Access looks at the query and sees a parameter
for which it needs to prompt for an input value.

Have you opened the query in design view and looked for a parameter?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[Marshall Barton]

I'm getting a pop up box when I try to open an exisitng, saved Query that
says "Enter Parameter Value" - I'm positive that that's a new thing, because
I've saved most of the Queries in there and never had to enter it before. How
can I disable that pop-up box?

Whatever you are prompted to enter is something you used in
the query. Maybe you misspelled a field name or mistyped an
expression.

 

[Dale Fye]

Make sure you actually look at the SQL, since the parameter may not be
visible on a criteria row in the design view.

Dale
--
Don''t forget to rate the post if it was helpful!

email address is invalid
Please reply to newsgroup only.