Can I FILTER reports using code

[viperstingray]

Is there any way that I can control the filter property of a report through a form? I want the user to select the client and facility that they would like to report on (using cascading combo boxes). Is there any way that I can use that selection to set the filter.

EX:
cboClient==> MICROSOFT
cboFacility=> California

I would want the report to use only show all Microsoft California facilities.

Your help is appreciated.

 

[WayneRyan]

viper,

DoCmd.OpenReport "YourReport",,,"[cboClient] = '" & Me.cboClient & "' and [Facility] = '" & Me.cboFacility & "'"

Wayne