Can anyone help?

What is the text you write in the criteria box if you want it to be sourced from a check box on a form? I want to be able to tick a check box and then automatically a value is put in the criteria for the query.

Cheers

If I understand you correctly you will need to have an SQL statment and a variable in the Where clause that is determined by the value of the check box.