Change Query Cretia from Form

[Luddite Lad]

I have a form based on a query, I would like to add additional criteria to the query dependant on the status of a check box. Is this possible if so what would the code look like?

 

[jeremypaule]

you'll probably need code. I'm thinking an IF statement checking if the check box is NULL if not run your query.

 

[statsman]

In your query enter the following into the criteria of the fields you wish to use:
[Forms]![Form1]![Text#]

With Form1 being the name of the form and Text# being the text box that contains the criteria.
You will have to create a macro or do coding for a command button to run the query from the form.

 

[Luddite Lad]

Thanks guys yes I had got as far as both of you had suggested, and I realise I need to implement some code. What I'm wondering is can I us code to add additional criteria to the query dependant on the state of a check box, and what would that code look like, if it can be done that way?