Turn filter off and on using code

D

David

I need to turn a filter off in a form using code. The
code I try is,

Reports![Company Information Main]!Data=[FilterOn]

which dosen't work. How can I alter the code in the form
to turn this filter off or on.
 
A

Allen Browne

If the report is named "Company Information Main", use:

Reports![Company Information Main].FilterOn = False

If "Data" is the name of a subreport, you cannot do that.
 

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

Top