ENTER PARAMETER VALUE

  • Thread starter Thread starter Sandra
  • Start date Start date
S

Sandra

I have an Access database, queries, and reports that I
have used for sometime. Now, all of a sudden, when I try
to open one of the queries or the reports, I get a
popup, "Enter Parameter Value". If I enter cancel, the
popup goes away, but the query or the report won't open.

Help!!!
 
I'll bet you deleted or changed the name of 1 or more
fields referenced by a query or report. What you are
seeing is Access' attempt to get the data you were asking
for but that it can no longer find.

If you open the query in question, you will see the
missing field replaced by "expr...". You need to change
this to the new field.
 
You are exactly right. Somehow a field was deleted in a
query. I didn't do it on purpose - don't remember doing
anything that would have done it accidentally, but it
happened. Thanks.
 
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

Automatically Enter Parameter Value 2
Popup Calendar to enter Date Range 1
Enter parameter value error 1
Parameters with mor than one crosstab query in a report. 8
IIf in a report based on select query -- problem w/parameters 2
Reference controls on a dialogue form as the parameters 1
Query parameters, charts, and reports in Access 2007 2
Mysterious Parameter Added?? 8

Back
Top