Printing the 'Filter' used to Report as text

[dws21]

I have a Form that has a command button with a link to a report with code to print just those records filtered, which works fine.

I would like to be able to pass the filter used to the report so that it can printed in that report's footer. I tried using a field on the report set to Me.Filter as it's control source, but when run it prompts you for this.

Any ideas on how I can print out the filter used to the report footer would be most appreciated.

TIA - David

 

[JoeMiller]

Make an unbound text box on your report and set it's ControlSource to this:

=[Reports]![MyReportName].[Filter]

HTH

Joe Miller
joe.miller@flotech.net

 

[JoeMiller]

You may want to show that there is no Filter enabled, to do that you can set the ControlSource equal to an IIf that checks the filter first like so:

=IIf([Reports]![MyReportName].[Filter]="","None",[Reports]![MyReportName].[Filter])

HTH Joe Miller
joe.miller@flotech.net

 

[dws21]

Joe,

Many thanks, that was exactly the info I needed, works a treat!

David