[AccessD] How to Obtain Access Report Filter information

Brad Marks BradM at blackforestltd.com
Sun Jul 24 15:39:58 CDT 2011


I am trying to build a VBA routine  to obtain report filter info.


The following line works nicely to obtain the filter for Report1 and
store it in a variable called str_Report_Filter

str_Report_Filter  =  Reports.Report1.Filter



What I would like to do is make this "Generic" so that I can plug in a
variable instead of the hardcoded "Report1"

 

Something along these lines...

 

Dim str_Report_Name

str_Report_Name = "Report2"

Is there a way to use a variable in a situation such as this?

str_Report_Filter = Reports.str_report_name.Filter 

(I know that this doesn't work. This is just an example of what I am
trying to do)   

 

I have tried many variations and tried to find an example on the
internet, but have not had any luck.

A simple example of how to do this would be most appreciated.

Thanks for your help/advice.

Brad   




More information about the AccessD mailing list