Criteria In Report Heading

[Laura]

I have a report that is based on pre-entry of a date range (effective and
expiration) on a criteria pop-up type form. Is it possible to show the
criteria date range on the report header so that anyone looking at the report
knows the criteria used?

Thanks

 

[Damian S]

Hi Laura,

Have an unbound text box in your report header with the control source:

="Criteria: Dates between " & format(forms!frmReportCriteria.dteStartDate,
"dd/mm/yyyy") & " and " & format(forms!frmReportCriteria.dteEndDate,
"dd/mm/yyyy")

Hope this helps.

Damian.

 

[Howard]

This is what I do but I think you will find the 'pop up type form' must
still be open for this to work.
One way is to make the button or whatever that initiates the report via the
pop up to only make the pop up invisible, not closed, while the report is
run. then put the form close code after the code that runs the report.
Where this code goes depends upon whether you run the report *from* the
popup form or *after* showing the pop up using a button elsewhere.
Howard