I have a form and one of the entities is a check box that is checked
when a record is closed out. How do I get the form to only show
records that are unchecked?? So once a item is checked it will not
show up on this particular form.

Thanks in advance...

Chris

Use a query for the Control Source for the form, where that check-box value
is false.

Mich

"Fatz" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> I have a form and one of the entities is a check box that is checked
> when a record is closed out. How do I get the form to only show
> records that are unchecked?? So once a item is checked it will not
> show up on this particular form.
>
> Thanks in advance...
>
> Chris

The checkbox must be a field in the table for it to be
saved. Then you can filter through the query that the
form is based on.

Jim
>-----Original Message-----
>I have a form and one of the entities is a check box that
is checked
>when a record is closed out. How do I get the form to
only show
>records that are unchecked?? So once a item is checked
it will not
>show up on this particular form.
>
>Thanks in advance...
>
>Chris
>.
>