Checkbox data in query: only when checked

[AsjenW]

I've got a search form where people can search for applicants with different properties. One of those is e.g. Has a Car.

I'd like the results of the query to show which people have a car when the checkbox is checked, and just to show all people (so no criteria) when the checkbox is unchecked. How can I do that, without having to use multiple criteria rows in the query (in design view)?

Thanks in advance!

[Robeen]

One possible way would be to have two separate queries set up - one of them that shows people who have cars and one that shows everyone.
Then - when your users click a Search Button on the form - if the check box is checked - display the 'hascars' query - otherwise display the 'everyone' query.
Hope this helps!