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.
 
Top