Do not show if check box is true

M

Michelle

I have a few forms one is for software and the other is for equipment.
When equipment goes to surplus we check a box so that it no longer shows on
a report the db generates. On the software form if the software is no longer
in use we check a box so that it is only showen in the no longer in use
reports. My question is....is there anyway that after the box is checked
they also no longer show up in the Equipment or Software forms other than
moving them to another table called old software old equipment.
 
J

Jeff Boyce

Michelle

There certainly is!

If you use a query to "feed" your forms, you can set a selection criterion
in that query to only take rows when the checkbox field is False. This has
the effect of only displaying "un-surplused" records.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Top