Access to choose only your department

A

Arnon

I have a database that has a big table with departments and their financials.

When opening a form the user is prompted to choose a department from a combo
box.

I want to put the database on a public folder, but limit the users to be
able to choose only their departments.

Is it possible to allow everyone to open this form but choose only their
departments? If yes, could you tell me how?

Thanks,

Arnon
 
K

Klatuu

Best way to do this is to implement security on your application.
Assign each department to a group.
Make each person in the department a member of their department's group.
In the open event of the forms in your app, write code to set the FilterBy
property to the department they belong to.
 
Top