Applying filters on Table Open

  • Thread starter Thread starter EHPorter
  • Start date Start date
E

EHPorter

I have a table containing various project files, most of which are closed.
They are flagged with a Yes/No field called "Closed" Ideally, when the
table is opened, it would display only those in which the "Closed" field is
blank; i.e., it would filter out the closed project files and display only
the open ones unless I deliberately cleared the filter.

I can create such a filter easily enough. I can not, however, figure out a
way to have the filter be the default state for the table. In other words,
I would like to have the filter applied automatically when the table is
opened.

Does anyone have any idea how to do this?

Thanks.
 
EH, what you should do is create a query that includes all the fields from
your table and filters out the closed projects. Save the query and work from
that, rather than from the table.

DDM
"DDM's Microsoft Office Tips and Tricks"
www.ddmcomputing.com
 
The nature of a table is to show you all records; the filters you can apply
to the table are temporary in nature. If you want to view a specific set
of records in a table - with a permanent filter - you should create a Query
which can be named and saved.


hth,
 
Back
Top