I know how to create and setup tables for a logon form, and also create the form itself. The DB I have only has two forms, so not too big. What I would like to do is when the user logs in to the DB, check what access they have and only allow the user to see the records that are relevant to them when they open the staff form.
Database Admin can see all data
Users can only see, edit records of the staff they manage
When form is opened the data is filtered to the user access level
Thanks in advance.