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

[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.

 

[Marshall Barton]

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*"))

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

 

[Gina K]

Perfect! Thank you.

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