Hi, I am new to Access and am trying to filter a combo box by user. I have multiple users entering and viewing employee records in this database and I do not want them to be able to view/enter information about themselves or employees at the same level as themselves, e.g. a supervisor can only view assistant supervisor and below and a manager can view only supervisor and below.
I have a login in screen and a navigation page that will only show forms that a user has access to, but can't figure our how to filter a combo box in those forms to remove themselves and people as the same rank or higher. For example we have an attendance form and I want users to be able to select only employees below their rank. Everything I have tried hasn't worked.
I have an employee information table, a user information table, user type table with access level numbers assigned.