how to have subreport use what user entered on main report

G

Gary Huckabone

I have a main report where the user enters a time period
that is invoked via a query. I'd like to use the same
criteria for a subreport but I don't want the user to have
to enter the period again. When I use the same query, the
user must input the same period multiple times.
 
D

Duane Hookom

Use a form with one or more controls for the criteria. Keep the form open
and enter beginning and ending dates in text boxes and then run the query.
The query criteria for both reports would have something like:
Between Forms!frmA!txtStart and Forms!frmA!txtEnd
 
Top