Parameter query prompts users twice

S

Slemaire

I created a simple parameter query, entering the text of a question,
surrounded by square brackets, in the Criteria portion of the Design view.
There is only one field that contains anything in the Criteria field.

It worked fine for a while, but now it's prompting me for the same question
twice before getting the query data.

Any hints?
 
J

Jerry Whittle

In design view, go to Query, Parameters. Is there something typed in there?
If so, does it EXACTLY match what is in the criteria of the query? Even an
extra space will cause the behavior you described. If there isn't anything
typed in there, there should be but that's a different conversation.

Is the problem with just a query or a report driven by the query? If a
report, check that you don't have sorting or grouping on a non-existant field.

For testing purposes, remove the parameter from the query. Does it still
prompt you for information? If so does putting something bogus in change the
results?
 
Top