Good day, I have a database with a table (tblEmployees) containing a column for Employees (Employee) and a column for the Business Unit (Bus_Unit) they belong to.
I also have a table for users who login to the database (tblUsers) and a Form with a login screen (frmLogin) which authenticates the user per username and password. The user is linked to a Business Unit which correlates with the Business Unit list in the Employee Table. I have declared the TempVars of the user (TempVars("EmployeeType") = rs!EmployeeType_ID.Value).
At the moment I have a Combox in a Form which looks up the the list of Employees from the tblEmployees table. The users who login must all have access to this form but should only see the employees belonging to their Business Unit when using the ComboBox drop-down menu. Is it possible to filter the list of Employees returned in the form's combo box, linked to a specific Business Unit in the tblEmployees table based on the user logged in (belonging to the same Business Unit)?