MS Access Login Form

[nescb]

Hi, I am developing a simple database in our office and and I need five login access:



Level 1: All Users
Level 2: Reception
Level 3: Employee Relations
Level 4: Admin
Level 5: System Admin

My knowledge is only limited to login form then it opens a switchboard.

Can you help me how to make it a point that when a user logs in, it will directly open to the target form and not anymore opens a switchboard.

Example:

Level 1: Login All Users, Password then opens All Users Form.

Level 2: Login Reception, Password then opens Reception Form.

Level 3: Login Employee Relations then open Employee Relations Form.

And so on...

Appreciate your great help.

[ranman256]

youd need a tUsers table,
USERID, RIGHTS

when user logs in, capture userid,lookup their rights , then allow the form to open.

[djspod]

This video and great tutorial was very useful in creating exactly what you want in your post.

https://youtu.be/DxRpo496w_c

Sent from my SM-N9005 using Tapatalk