setting filter on a subreport

  • Thread starter Thread starter Guest
  • Start date Start date
G

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?
 
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."
 
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.
 
Back
Top