Setting a filter on a subreport

[srmclean]

Hi,

Am having a bit of trouble setting a filter on a subreport. I set up a filter string elsewhere and store in a variable and then use the following on the main report: (which works fine)

Private Sub Report_Open(Cancel As Integer)
    Me.Filter = varSummaryMainFilter
    Me.FilterOn = True
End Sub

What I can't do is use the same on the subreport :

Private Sub Report_Open(Cancel As Integer)
    Me.Filter = varSummarySubFilter
    Me.FilterOn = True
End Sub

Getting a "The setting you entered isn't valid for this property" error.

It works if I open the subreport on it's own but not under the main report... any thoughts anyone??

I can't seem to set the property via :

Me.subReport.filter = varSummarySubFilter

either .....

----------------
Shaun McLean

 

[Remou]

Hi
Maybe (?):
Me.SubReportName.Form.Filter = varSummarySubFilter