Runtime error 2101 - The setting you entered isnt valid for this property.

Hi,

I have a report & a subreport. I wish to apply a filter to the subreport
when it opens so ive added the following code to it:


Private Sub Report_Open(Cancel As Integer)
Me.Filter = "YearOfPublication = 1926"
Me.FilterOn = True

End Sub

When i open the subreport on its own this works fine but when i open the
main report i get the following error message:

Runtime error 2101 - The setting you entered isnt valid for this property..

any help much appreciated


cheers

jim