Check box to filter subform

Joined
Apr 23, 2010
Messages
1
Reaction score
0
Hi,
Iam trying to fiter a subform using a command button basing the filter on the value of a checkbox the code iam trying is:
Me.Filter = "[Existing] = '-1'"
Me.FilterOn = True
"existing" is the field name of the checkbox on the subform but this is not working
Any help would be much appreciated.
 
Back
Top