I'm going to assume you use macro to run query. Then you would need a query that returns records for both checked and not checked. But how do you decide when to run this one? When the form is open and records are loaded, checking box that was checked will turn it to False, not Null. You have to click when False to turn it to Null. I think this would be unreliable.
Maybe put an option frame on the form with 3 buttons and a frame label that describes what it is for. 1 button for query all checked, 1 for query all not checked, 1 for query both. When macro runs, it checks value of option frame.
Last edited by Micron; 10-08-2018 at 10:00 AM.
Reason: clarification & added info
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.