Help on ApplyFilter

[cin2002]

I would like to filter the report without open it.
I tried as following:
DoCmd.SelectObject acQuery, "qryName", True
DoCmd.ApplyFilter , "[date] Between #01/01/02# And #04/11/02#"

I get a run-time error '2488': You can't use the applyFilter action on this wonder.

Anyone can help me solve the problem?

 

[larryww]

I assume this is Report_Open code. Change it to
Me.filter = "[date] Between #01/01/02# And #04/11/02#"

(if you actually have a variable called "Date" - even "MyDate" would be an improvement )

 

[cin2002]

But I don't want to open the Report. As I say, I want to make the filter without open the report because I need to export the report to excel.