Hide with Query

[Djblois]

I want to create a query so that if a checkbox is checked then it will show all items but if it is unchecked I want to show only items that the field Dep_Time is still blank. How can this be done?

 

[madEG]

I don't think you merely want a query, but rather some VBA code that checks the condition of the checkbox and toggles the recordsource between two queries, one that select * from tablename, and the other select * from tablename where condition is met...