How to match criteria between subreports and Report?

[Guest]

I am trying to run subreports in a main report. Eventhough the search
criteria for both reports are the same (Start Date through End Date), the
criteria is being asked for each report. How do I set up the report so that
the user only has to enter the seach criteria once.

 

[Guest]

Hi GulfCost,

Use a form to store your start and end dates, then refer to them like this:

between forms!frmReports.dteStartDate and forms!frmReports.dteEndDate

Assuming your form is called frmReports and your controls are called
dteStartDate and dteEndDate.

Hope this helps.

Damian.