Report based on date range
You could store the values in an invisible form control prior to opening the
report and then read them and display them.
You could pull the values from the Filter property. Try add a text box to
the report header with a control source of
=Filter
If the variables are global, you could use code in your report to set the
caption of a label.
--
Duane Hookom
MS Access MVP
Quote:
> I have 2 variables dtmBegDt and dtmEndDt. Each is tied to an Inputbox.
> I pass these variables to a report's underlying query with the
> OpenReport method's WHERE clause.
> Is there some way I can pass these variables to a control on the report
> header to yield "REPORT 1 - " & dtmBegDt & "TO " & dtmEndDt ???
> As a newbie, I haven't had much luck in finding the solution.
> Your solution or alternative method would be appreciated.
> Thanks,
> Don
