opening different forms for different users

[dana_cc]

Hi,
I need a VBA function or code that will allow me to read username and password and then open the correct form for that password if it exists and tell the user if it's wrong. for example:

the first thing when accesing the program the user will be asked to enter a password. then if they are managers they will see the managers opening form and if they are employees they will se a different opening form with less options and different forms/reports.


thanks.

 

[john471]

This is a duplicate post of This Thread.

Please don't duplicate post.