Bogus Parameter Value Dialogue Box

  • Thread starter Thread starter George Reamy
  • Start date Start date
G

George Reamy

Although a relatively new user, I've been creating
reports for a bit now, and never had this problem
before. After I use the wizard to create a report and
tweak it in design view, I get an "Enter Parameter Value"
dialogue box that pops up when I try to go to the
datasheet view. It's asking for parameters for multiple
fields. I have not consciously done anything to make
this box appear.

How do I (1) get rid of that box in an existing report,
and (2) keep this from happening in the future.

--George
 
Basically, the Report referred to some name that Access couldn't find in the
RecordSource of the Report and therefore it is assumed to be a Parameter.

Have you change the RecordSource Query of the Report?

You might have used the name of a Field that you have deleted from the
RecordSource Query or you have used aliases of the Field names.

Make sure you also check the Report's Sorting and Grouping since Field names
are used in Sorting and Grouping also.
 
Back
Top