setting filter on a subreport

[Guest]

I'm trying to set a filter within a subreport. When I run the report, I get
an error on the line that sets the Filter property. It errs out even if all I
do is set the filter to blank.
I've stripped the code down to the most basic it could be. It's in the
subreport:
Private Sub Report_Open(Cancel As Integer)
....
Me.Filter = ""

What do I need to do to set a filter on a subreport?

 

[Guest]

I suppose it would help if I said what the error message is. "Run-time error
2101: The setting you entered isn't valid for this property."

 

[SA]

Eachus:

You can't set a filter on a subreport as you've seen. You need to use the
LinkChild / Link Master properties to filter the sub based on data in the
main report.