I'm trying to filter my report while my report remains open. I have a form that opens when the report opens. The form has three combo boxes that are used to filter the form. On each combo box AfterUpdate event I have the following code:
That code will filter the report for the first time, but if I change to another value the code doesn't do anything.
I want to be able to filter my report without having to close it or the filter form. I need something like a requery but you can't requery a report or can you?
Code:
Dim rpt As Report
Set rpt = Report_rptIssuesReport
rpt.Filter = "[Vendor] = [Forms]![frmFilterReport]![cboVendor].value Or [Forms]![frmFilterReport]![cboVendor].value Is Null"
rpt.FilterOn = TrueThat code will filter the report for the first time, but if I change to another value the code doesn't do anything.
I want to be able to filter my report without having to close it or the filter form. I need something like a requery but you can't requery a report or can you?
