Show filter on table

[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

 

[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

 

[Tom Wickerath]

Hi Andy,

Open the table in design view, and then click on View | Properties. You
should see a filter property (I'm assuming you are not using Access 2007).


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[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.