Parameter query in subreport prompting twice! 3

[beadgirl]

Hi again,

No VB or SQL here - just using Access' built-ins. The field is Location. In the parameter query, the criteria is [Enter Store Number]. Then the qry also pulls in city and state. Works just fine.

I have a report with unrelated data from an unrelated table. I want the user to be able to just enter a store number and have the city/state pull up. So I made a subreport from the qry above. If you preview just the subreport, it works fine.

If you preview the main report, you get the "Enter Store Number" prompt two times. If you enter it twice, the report looks great. What's happening?

Thanks,
beadgirl

 

[beadgirl]

YAAAAY!!!! It worked! The reason that Pauls original suggestion didn't work for me is... drumroll... I forgot to change the name of the text field in the form! Duh... It was still set to "Text0"... So when I changed it to txtLocation and changed it in the query, it works PERFECTLY!
Thank you lameid, thank you Paul, and Mike and all the rest - I appreciate all of you throwing your suggestions at me! I learn so much every time I have a problem. Too bad it takes days of beating my head against the wall!
Thanks again...
beadgirl

 

[beadgirl]

And I forgot - thanks to GDGarth for the original suggestion to get the data for the query using a form! Something I've never had to do before. You guys are the best