Checkbox filter

[cbende2]

Hello all,

On my continuous form, I have a field that is a checkbox. I would like to place an unbound checkbox/radiobutton in the form header so that when the it is checked, it will display only records that are checked, and when it is unchecked, it will only display records that are unchecked.

Any help will be greatly appreciated!



Thanks

[ranman256]

sub chkBox_AFTERUPDATE()

me.filter = "[field] = " & chkBox.value
me.filterOn = true

end sub

[cbende2]

Thanks for the reply, I created a Combobox with Yes/No values and am using that. Thanks though ranman!