Apply Filter

[Guest]

I have a form that is built off of a single table that is home to a large
amount of information. One field on the form contains an identifier for the
type of info contained in each record on the form. Is there a way to filter
the info on the form for one specific identifier using a command button, or
other tool. I would also like to be able to remove the filter and see all
the records without having to close the form and reopen it.

Thank you

 

[Al Camp]

Place your cursor in the field you want to filter by, and right click.
You should see a list of Filtering Options to use, including remove.
hth
Al Camp
Candia Computer Consulting - Candia NH
http://home.comcast.net/~cccsolutions