Enter Parameter Value?

[Zack Barresse]

Hello all,

I'm not understanding this message I keep getting when I open a report. It
asks me if I want to Enter Parameter Value for one of the fields. If I
click Ok through it, the report looks fine. If I press Cancel, the report
does not open. How do I suppress this input box?

I'm still learning. Thanks.

 

[Marshall Barton]

I'm not understanding this message I keep getting when I open a report. It
asks me if I want to Enter Parameter Value for one of the fields. If I
click Ok through it, the report looks fine. If I press Cancel, the report
does not open. How do I suppress this input box?

That message is called a Parameter Prompt and it appears
whenever a query runs across a name that is not in the
query's base table.

If you did not intend to prompt for a value, the cause is
typically a misspelled name or the name of a field in the
table was changed and you forgot to fix the query. You can
test for this situation by opening the query directly from
the query design or database window.

If you do not get the parameter prompt message from the
query by itself, then the mispelled or extraneous name is in
the report instead of the query.

In this case check the report carefully for the name. It
may be used in a control's ControlSource property or in
Sorting and Grouping.

Make carefult note of the name that you are being prompted
for a value. Then fix the field name's spelling in the
query or report.

 

[Zack Barresse]

Hi Marshall,

I did have a field which did not match any in the query's table, so I
renamed it to the correct field name (from "Sampled" to "SampledBy") and
everything matches, but I'm still getting the prompt. Do you know what else
I could check?

I did check the SQL statement and all the field names match and I did not
see anymore "Sampled", yet it still prompts for that parameter.

 

[Marshall Barton]

I did have a field which did not match any in the query's table, so I
renamed it to the correct field name (from "Sampled" to "SampledBy") and
everything matches, but I'm still getting the prompt. Do you know what else
I could check?

I did check the SQL statement and all the field names match and I did not
see anymore "Sampled", yet it still prompts for that parameter.

Do you get prompted for that name when you run the query by
itself?

Don't forget to check the report for uses of that name too.

 

[Zack Barresse]

Okay, found it. Wow, that took a LOT of digging! I just stumbled onto it
too, would never have thought to look there. The table this report is
linked to had the field labeled "Sampled" and not "SampledBy", but that is
what I had the control pointed to. See, at some point, both fields existed
in the table. Confusing as heck to me. But all works well now. Thanks
Marshall, much appreciated!