This Problem has been a big pain.. It seems simple enough but I cannot get over this error.
I need to access 2 forms only if the Password entered in an Inputbox is correct. So I have created a table called PasswordT where I have the Passwords saved, each with a pass ID (text ID). Once the user clicks on a command button, a message box asks for the Password. The user then enters it and the code looks for the Password with the same pass ID, using Dlookup, and checks if the inputted Password is the same. If yes, it opens a new form.
My Password table is called PasswordT. The ID is called PasswordID and the actual Password is called Passw. The code in vba is:
strPasswd = DLookup("[PasswordT]", "Passw", "PasswordID = 'Herford' ")
But I Keep on getting the 3078 error. Any clue what I am doing wrong?