Variable Filter

[breana]

This is the situation, I'm new to access:

Table_1
User1 is assigned to Site1, Site2, Site3
User2 is assigned to Site2, Site4
User3 is assigned to Site4

Table_2
Contains info on all sites

Now how do I filter the information displayed for user access?

I want User1 to see his assigned sites on Table_2, obviously not all sites.
I want User2 to see his assigned sites etc, etc


....

How do I do this, any help will be highly appreciated!

[breana]

I found a solution but the fields are not updateable. Please help!

[breana]

Is there other way aside from using a query and then be able to modify records?

[orange]

What is the issue with a query?
If your concern is that
a) user 1 and user2 both access site2
b) user2 and user3 both access site4.

Can you restrict user update to specific records at a site?

[breana]

Hello Orange,

I was able to filter users according to their assigned sites but they can't update records (error message was "recordset is not updatable")

Users who are not assigned to a site should not display other user's site records. My only problem with that query I did was the user was unable to modify records.

Thanks for any help you could provide.

[breana]

I've attached an mdb, see how to make the query able to modify records. thanks!