Sub-report okay as stand-alone, but Filter expression errors when used as sub-report

[GraeagleBill]

I have a sub-report that formats and displays properly when run by itself. The On-Open code:



Private Sub Report_Open(Cancel As Integer)
Me.Filter = "[Provide Ride] > 0 AND [RetYear] = '2013'"
Me.FilterOn = True
End Sub

However, that same code gets an error at Me.Filter = "[Provide Ride] > 0 AND [RetYear] = '2013'" when I attempt to run the parent report.


I'm clueless as to what's different between the two.
Any ideas as to what causes the error?
Thanks,
Bill

Here's the error. (Too bad one can't paste images into a post)

[June7]

Could set those criteria in the subreport RecordSource SQL.

[GraeagleBill]

I keep jerking myself around on this one. I'm going to return to the idea of establishing a two column report and establish the two groupings. I just need to find out how to get the group section properties to come up so I can specify "NewRowOrCol" property.