Setting the Filter of a table using VB

[Sue Mulcahy]

I have a database that is already programmed. Now they want to have it that
it will only show specific data depending on who is viewing it. I see there
is a filter property in the table when I open it up in design mode. To get it
to actually filter the data, I need to click on apply data. Is there any way
that I can set this filter on when the database is opening up by using VBA?
Please advise..

Thanks.

 

[solex]

Sue,

Have the users open up the table via a query instead of directly accessing
the table

Dan