Show filter on table

A

Andy

I have a table to which I have applied a filter. Is there anyway to see what
the filter criteria is (yes, I should remember as I only did it 30 mins ago)
as I need to know it.

Thanks
 
J

Jeanette Cunningham

Andy,
switch the table to design view
open the property dialog for the table (from a button on the toolbar)
on the property dialog, next to the Filter property you will find the last
filter you applied.

Jeanette Cunningham
 
P

Pat Hartman

Don't work with tables directly - work with forms. You can then add a
control on the form that shows the current filter. If you like datasheet
view, you will probably be happier with an unbound main form and a datasheet
view subform. The main form will give you a place to place buttons and the
filter text box. Forms in DataSheet view to not show their headers and
footers so they have no place to hang other controls.
 
Top