how to have subreport use what user entered on main report

  • Thread starter Thread starter Gary Huckabone
  • Start date Start date
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.
 
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
 
Back
Top