Hide any records that a condition is not met.

[tweeter85usn]

I am using Access 2003.
I am looking for a way to hide any records in a database that a specific condition is not met.

e.g.

If [Age] = "25" then
Record.visible = true
Else
Record.visible = false

I don't know how to go about doing this and I will be grateful for any help.

 

[John Big Booty]

Create a query that uses the specific criteria you mentioned above and use that as the Control Source for your form.