Parameter query prompts twice

S

Slemaire

I created a simple parameter query for one field in my database, which seemed
to work fine. After a few days, it started prompting me twice for the
parameter. I got the same problem with my associated form.

I couldn't figure out how to fix this, so I deleted the query and created a
new one, but does anyone know what could have caused this problem?
 
K

KARL DEWEY

The most common reason is that the prompt was edited. A leading or trailing
space added or some other modification. This happens when the prompt is used
in two places such as criteria and as an output. To avoid this from
happening I always typed it the first time and then copy-paste everywhere
else.
 
B

Bonnie

Hi. Not a programmer but it's happened to me alot. Usually I check the sort
or filter lines in my query properties. Happens if I sort a column in my
query results. Can mess up a parameter inquiry. Also, check your index
list, it might have changed. HTH.
 
Top