parameter value

[slimjen1]

All; using ms access 2010. In the query I use for a report; I put a parameter so the user can filter a date. It works fine but now when I go to open a form that has a subform relating to the report; users get the popup for input also. This doesn't stop the form from opening but it is annoying. There is a subform on this main form relating to the report, but the subform has a table not query for the recordsource like the report. None of the queries related to the main form that's asking for the parameter values have the parameter inthe queries. I am stumbed. Does anyone have any suggestions on how to get rid of the parameter popup?

 

[GinaWhipp]

You checked the Subform's Recordsource what about the Recordsource for the Main form?

 

[slimjen1]

Yes I have. I will dig deeper.

 

[GinaWhipp]

Hmm, then check the OrderBy and Filter lines in the Property window for both Forms.

 

[slimjen1]

Correction. I found that the query used for the report is the same query used for the subform on the main form. I can make a copy of the query and use one for the report and the other for the main form. Any other suggestions?

 

[GinaWhipp]

You still haven't checked the OrderBy and Filter properties of the Form, not the query...

 

[slimjen1]

ok. I checked both form. Both filter by and order by is blank. The parameter was in the query for the subform.

 

[GinaWhipp]

Oh, okay, I misread your earlier response!

 

[slimjen1]

thanks for your help. Closing out