Two parameter entry prompts - should only be one

[Guest]

I have a simple query to retrieve information related to the employee ID
entered in the parameter entry pop. I recently started getting the same pop
twice while trying to run the query. I have the [Enter Empl ID] in only one
place, but if I don't enter the same ID in both pops my query bombs. How can
I get rid of the second pop without recreating the query? thanks

 

[Guest]

This normally happens when you have it twice but not the exact same spelling
such as leading or trailing space.
Paste your SQL in word and search on 'Enter' just to check.

Did you also use it in the output field grid to carry the response to a
report or form?

Try entering the wrong information in the first prompt such as 'XXXXXXXX'.

 

[John Spencer]

This sometimes happens if you are viewing the query directly and have
applied a filter (or sometimes a sort) to the parameter query.

An easy way to fix it is to switch to SQL view, copy the SQL, open a new
query (don't add any tables when prompted) and paste the SQL into the new
query. Try running the new query, if it works save it over the old query or
save the old query as OldQuery_BU and then save the new query with the old
query's name.


--
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
..