Set "Filter On" property in a report?

[johndoh!!]

I have a form with a button (to open the report) and a check box (to say all sub-records). I have a filter in the sub-report set to list only one specific sub-record. Can i change the "Filter On" value from "Yes" (default) to no based upon whether the check box is checked?

I am trying this:
If (checkbox) = NO then
Set "Filter On" to NO
End If

Any ideas? The above does not reflect the actual code, only the idea!!

Doh!!

[This message has been edited by johndoh!! (edited 02-27-2002).]

 

[Alexandre]

If Me.YourCheckBoxNameHere = False Then
Me.Filter = False
Else:
Me.Filter = True
End If

Or more syntetically:

Me.Filter = Me.YourCheckBoxNameHere

You have to get a few references on VBA and study them. Syntax is not something you can guess.

Alex