Clearing Filter Property

[momon]

Does anyone know how to clear the FILTER property field under the DATA tab for REPORTS using VBA?

I have a report that can be accessed through the switchboard or is automatically opened when a particular form is closed. The problem is that when the report is accessd through the switchboard, filter#1 is applied. When the report is automatically opened by closing a certain form, filter#2 is applied.

Currently, the report always opens with either filter#1 or filter#2.


I tried the following code to clear the FILTER property but it doesn't seem to work.

Private Sub Report_Close()
Me.Filter = ""
End Sub

Thanks in advance.