parameter query asks for parameters twice 1

[leeroi]

I have several parameter queries which initially worked fine, but have recently for no apparent reason (at least not apparent to me!) begun to prompt me for parameter information twice before they will display the results.

Is there a simple explanation/fix for this?

Thanks,

Lee

 

[mpastore]

Can you post query here?

Mike Pastore

Hats off to (Roy) Harper

 

[leeroi]

I'm not sure why, but when I reordered the sequence of parameter fields in the query design, the problem went away.

Strange!

"The more I know, the more I know I don't know"

 

[chuckg0413]

I have had this problem also. Here is what I do to fix it.
Let's say I have a table with lname, fname, city, state. I want to have a query that finds all lnames from a state, and another that finds all fnames from a state. So I create the queries with [What State] as the parameter in both. Now when I run the lname query it asks "What State" twice, same if I run the fname query, but if I change "What State" in either of them to something like "Which State", leaving the other query alone, then it only askes me once.
I am far from an Access expert, and there are probably a lot more elegant ways to fix this, but it works for me.