Need to quickly clear yes/no field

[fishtek]

I have a boolean field in a table that users check yes or no to filter unrelated records in a query. Is there a quick way with code or other to allow users to quickly clear out all checks in the field before starting a new filter? I suppose they could sort to bring all checks to the top and then remove, but I was hoping to accomplish with something like a clear button. Thanks for any help.

 

[PHV]

In the Click event procedure of the button:
DoCmd.RunSQL "UPDATE yourTable SET yourBooleanField=False"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[fishtek]

Thanks PHV.... worked like a charm!