Access to choose only your department

[Guest]

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

 

[Rick B]

Have you implemented User-Level Security? If not, you need to do so.
Do you have them locked out of the tables? If not, then they could simply
open the tables to view the data.
How about the queries? Can they open the query and view data they
shouldn't? If so you need to lock them out of the queries and set them to
run with owner's permission.

After you've done that, then you need to hard code the form to only pull a
particular department. Don't let them pick. To figure out which
department, you will have to have a table that includes the "CurrentUser"
name used to open the database, and the department.

Lots of steps to get here. The first is getting security set up and locking
down all the tables, queries, and the ability to add new queries.