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.
 
Back
Top