Subreports

[Gary]

I have several reports where each one prompts the user to type in a date.
I want to include all these reports in a single report. These reports will
become subreports in this single general report.
When I open this single general report containing the subreports, I will be
asked (prompted) to enter a date several times. In other words, I only want
to be prompted once so that these subreports produce their result in one go.
How can I achieve this without getting many prompts.
thanks.

 

[Allen Browne]

Create a form with some unbound controls where you can enter the limiting
values.

Then have the queries read the values from the form. The Criteria will be
something like:
Between [Forms].[Form1].[StartDate] And [Forms].[Form1].[EndDate]