Is there a way to print what I’ve filtered for on a report?

  • Thread starter Thread starter Gina K
  • Start date Start date
G

Gina K

If I filter a form and use DoCmd.OpenReport “MyReportâ€, acPreview, ,
Me.Filter to open My Report, is there a way to print the filter somewhere on
the report? Something like:

((MyQuery.ACTUALSHIP Between #1/1/2007# And #1/31/2007#) AND
(MyQuery.PARTNUMBER Like "433*"))


Thanks.
 
Gina said:
If I filter a form and use DoCmd.OpenReport “MyReport”, acPreview, ,
Me.Filter to open My Report, is there a way to print the filter somewhere on
the report? Something like:

((MyQuery.ACTUALSHIP Between #1/1/2007# And #1/31/2007#) AND
(MyQuery.PARTNUMBER Like "433*"))
Click to expand...


I believe the report's Filter property will contain the
WhereCondition argument string.

You can then use a text box with the expression:

=Report.Filter
 
Perfect! Thank you.

Marshall Barton said:
I believe the report's Filter property will contain the
WhereCondition argument string.

You can then use a text box with the expression:

=Report.Filter
Click to expand...
 
Back
Top