Using Subform's Filter & FilterOn Propety from the Main Form

G

Guest

I am trying to use the Filter and FilterOn properties of a subform. If I was
writing the code in the subform, I would use the following code:

Me.Filter=strWhere
Me.FilterOn True

I thought that if I needed to code this same function at the main form's
level, all I would have to do is the following as a result:

Me.subForm.Form.Filter=strWhere
Me.subForm.Form.FilterOn True

However when I try to run the code, it gives me a compile error for the
FilterOn property.What changes to the code do I need to make in order to turn
on the filter?
 

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

FilterOn Causing a Problem 3
How to edit a continuous subform's recordset in batch 5
Refreshing filter on Subform in Access 2010 0
Filter Problem 1
Subform causing #error on main form when referencing controls 1
Trying to use the filter on the form to filter report 3
Filtering subforms via main form 2
Search Form with a SubForm 3

Top