Yes/No Query to include some or all results

[Waster]

I'm having a mental block on this one.

I have a table with a yes/no field. It's linked to a form with a yes/no box, but the outcome I want is that if the form box is unchecked, the query returns all the "yes" records - which is trivial; however I want to return ALL the records if the form box is checked.

I've tried searching for this, but as you can see it's a bit tricky to put into words...:banghead:

 

[Galaxiom]

Add this to the end of your query

OR Forms!formname.chckboxname

(Comparison to True is not essential because the value is boolean)