MsgBox "Password Invalid. Please Try Again", vbOKOnly, _
'If User Enters incorrect password 3 times database will shutdown
intLogonAttempts = intLogonAttempts + 1
If intLogonAttempts > 3 Then
MsgBox "You do not have access to this database.Please contact admin.", _
vbCritical, "Restricted Access!"
However, I would like to open different forms for different users. I have a table of my users, which has a field with the name of the form I want that user to have access to, so I was wanting the code to lookup that form name to know which form to open. ??? Can anyone help with this? Also, I know very minimal VBA, and even less about Access security. Thanks so much!!