Setting the Filter of a table using VB

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
Sue,

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

Dan
 
Back
Top