reports parameter

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report that is composed of several subreports.
ALL the subreports use their own parameter queries. The queries
each have a beginning and ending parameter in the date
field. ([Start Date] and [End Date]) When I run the
main report, the user needs to enter the Start and End
date 5 times - once for each subreport.

How can I tie together the parameters so the user only
enters the Start and end date once.

Thanks in advance for your Help
shah
 
shah said:
I have a report that is composed of several subreports.
ALL the subreports use their own parameter queries. The queries
each have a beginning and ending parameter in the date
field. ([Start Date] and [End Date]) When I run the
main report, the user needs to enter the Start and End
date 5 times - once for each subreport.

How can I tie together the parameters so the user only
enters the Start and end date once.
Click to expand...


Use an unbound form to start the report. Add text boxes
txtStart and txtEnd for the start and end dates and a button
to run the report. Then, change the each report's
RecordSource query to use the text boxes for the parameters.
I.e. instead of the criteria:
Between [Enter Start Date] And [Enter End Date]
use:
Between Forms!theform.txtStart And Forms!theform.txtEnd
 
Back
Top