Date Range on a report that has multiple date dependent sub report

[Guest]

I have designed a DB that generates a report that has multiple sub reports in
the final report. Each sub report needs a date range. It does ork now if I
enter the beginning and ending date of each sub report . I have 2 problems.
1. Want to enter the date range only once
2. When I try to print the report it makes me enter the date ranges again.
Can anyone simplyfy this process with maybe a pop up bos or sometinhg?

 

[John Vinson]

I have designed a DB that generates a report that has multiple sub reports in
the final report. Each sub report needs a date range. It does ork now if I
enter the beginning and ending date of each sub report . I have 2 problems.
1. Want to enter the date range only once
2. When I try to print the report it makes me enter the date ranges again.
Can anyone simplyfy this process with maybe a pop up bos or sometinhg?

The simplest solution for this is to use an unbound Form (let's call
it frmCrit) to enter the criteria. frmCrit should have two textboxes,
txtFrom and txtTo; your query criteria would use something like

BETWEEN [Forms]![frmCrit]![txtFrom] AND [Forms]![frmCrit]!{txtTo]

If you put a command button on frmCrit to open or print the Report,
you can save the user a step.

John W. Vinson[MVP]