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

G

Guest

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error 2101 3
Set filter in subreport 7
Filter problem 0
Filter not working in sub report 1
Me.Filter on Subreport does not work? 1
problem applying filter to a subreport in vba 2
Filtering a Subreport 7
Runtime Error 2001 you canceled the previous operation 5

Top