Date Parameters in a Report

[Shannon3778]

Help!! I'm really stumped! I've created queries with date parameters and I created reports from those individual queries. Now, I'm trying to create 1 big report with all of the query reports in it as sub reports. I was able to create it, but now, when I click to run the report, it asks me for the parameters 15 times (the same # of sub reports that are in the final report). I want the user to only have to enter the date parameters 1 time... how can I do this???

 

[pbaldy]

Have the user enter the dates on a form and have all the queries point to that form.

 

[Shannon3778]

Please forgive my ignorance... I'm desperately trying to teach myself access... what are the steps to do that??

 

[pbaldy]

In the query, instead of

[Enter date]

You'd have

Forms!FormName.TextboxName

And the form needs to be open when the query runs.

 

[Shannon3778]

Great! I'm almost there!! How do I enter the date parameters on the form though??

 

[pbaldy]

I'm not clear what you mean. The user would enter the dates on the form. Typically you'd also have a button to open the report.