userform to log in based on password and security level

[just_some_guy]

Hello all,

I have an Access 2007 database that I have set up to have a user id to log into. That is working perfectly. I want to add another item for the login to look at which will say something along the lines of "your password matched, and your security level is 2, so this switchboard will open" or "your password matched and your security level is 1, so this switchboard will open."

I'm not even sure quiet where to begin to do this.

Here is the code I am using for the log on

Please Login or Register  to view this content.

Any ideas on what I would modify to get this to do what I need?

Thanks!

[davegugg]

Just store the security level and corresponding switchboard in a table and link each user to a particular level and switchboard. You can use Dlookup again to find which security level to announce and which switchboard (form) to open.

There are a few things to remember when using a form to open access to different security levels. You need to make sure the user can't close the form without the database exiting. You definitely want the form modal, and control the form exit through a button control. Disable the X in the upper right corner by setting the Close Button property to No.