Re: Enter Parameter Value?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

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.


--
Regards,
Zack Barresse, aka firefytr



"Marshall Barton" <marshbarton@xxxxxxxxxx> wrote in message
news:9pkv52dtqu2fa426vdek1vd140iungl4qg@xxxxxxxxxx
Zack Barresse wrote:
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.

--
Marsh
MVP [MS Access]


.

Relevant Pages

  • Re: Criteria prompts
    ... how do I specify a "name" prompt? ... report, which is linked to a query. ... set this criteria to come up as prompts when the report is run? ...
    (microsoft.public.access.reports)
  • Re: Criteria prompts
    ... how do I specify a "name" prompt? ... report, which is linked to a query. ... set this criteria to come up as prompts when the report is run? ...
    (microsoft.public.access.reports)
  • Re: UPDATE DATE FIELD IN QUERY
    ... In the Date Field of my Query I have entered the following into the Criteria ... I can open the query, and it does prompt start & end dates, but it opens the ... When I open the report it opens the same parameter window & not my form, ... End dates 6 times & it just kept bringing up the prompt. ...
    (microsoft.public.access.macros)
  • RE: Search memo field using criteria from a Form
    ... I've set the record source to be the query... ... using the prompt box as a key word search for a memo field so I want to be ... able to display on the report the value the user entered in the prompt box. ...
    (microsoft.public.access.queries)
  • Re: Multiple criteria
    ... An undefined name in a report control's expressions is ... text box to prompt for a value (such as a starting page ... parameter in the report's record source query can be ... >>>It doesn't seem to make any difference what date format ...
    (microsoft.public.access.reports)