Apply a Filter to a Form

[chaddresnick]

How do I apply a filter that automatically loads when a form is opened? For example, I have a check box and I only want to load records where the box is checked.

[NTC]

There are 2 approaches fundamentally:

* use the record source - i.e. query - to establish the record set
* use a full record set but apply a filter to the form property - this is accomplished in the 'Where clause' that is part of the command argument which is opening the form such as a command button's property