Mystery pop-up

N

Novice2000

Hi,

I have a pop-up every time I try to run my report. It is an "Enter parameter
value" pop-up requesting input. I just click it off, but it is very annoying.
I have no idea what data is requesting input, since this field doesn't seem
to be included in the report. Is there any way to clear this off of the
report?
 
G

gls858

Novice2000 said:
Hi,

I have a pop-up every time I try to run my report. It is an "Enter parameter
value" pop-up requesting input. I just click it off, but it is very annoying.
I have no idea what data is requesting input, since this field doesn't seem
to be included in the report. Is there any way to clear this off of the
report?
Click to expand...

Check the query that's generating the report. Sounds like there is a field
name misspelled or it just doesn't exist.

gls858
 
J

John Vinson

Hi,

I have a pop-up every time I try to run my report. It is an "Enter parameter
value" pop-up requesting input. I just click it off, but it is very annoying.
I have no idea what data is requesting input, since this field doesn't seem
to be included in the report. Is there any way to clear this off of the
report?
Click to expand...

You'll get this popup if the Query underlying the form contains a name
in square brackets which is not recognized by Access: it could be a
misspelled or missing fieldname, or a criterion, or in an expression.
Or, perhaps the Report has such a value in its Sorting and Grouping
dialog or in an expression in a textbox's Control Source.

It may take some searching to find it, but it's surely there
somewhere!

John W. Vinson[MVP]
 
Top