I have an existing database that is working fine. I took of copy of the database and made some enhancements with the addition of some tbls, queries and forms. I used the database copy to test out using a Password. It worked perfectly. This weekend I moved all my new objects (tbls, queries and forms) into the existing database. Everything came over fine.
I copied the password event procedure and put it in the same place but it is not recognizing it when I click on the form. I am not sure what to check next.
Code:
Private Sub Page84_Click()
Dim PassWord As String
If PassWord = "Superman" Then
DoCmd.OpenForm "Page84"
Else
MsgBox ("Access Denied")
End If
End Sub