Subreport Control Reference

[SgtTurbo]

There is a report with 2 unbound sub-reports. I'd like to filter each sub report for a specified date range (the same range for each). If I put the criteria in design of each sub report it filters for the dates entered but asks for each date twice (once for each report). I'm struggling with the coding to reference the fields on each sub report. I was hoping to have a cmdButton on the main form that opens this report and passes the start and ending dates entered once to each subreport.

I found this coding, but it doesn't seem to work:

Reports![MasterReportName]![SubReportName].Report![Field] Between [Enter Start Date:] AND [Enter End Date:]
 

[PhilOfWalton]

I suspect your approach should be to have the start & end dates on your form and have the sub report's underlying query have criteria referring to the dates on the form

Something like Between Forms!MyForm!StartDate and Forms!MyFormEndDate

http://www.knowledgewave.com/blog/ms...e-range-2.html gives a simple set of instruction.

Phil