Password verification

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

I have a form (frmpassword) with an unbound text box
(text0) I would like for the text box to verify the
password against a table (tblPassword)which has a field
named (password). Also, if the password is wrong to return
an error message that states: Wrong Password! Re-enter.

Thanks for your assistance,
Bill
 
Hi,
Does tblPassword only have one record in it?
If so, use DLookup:

If IsNull(DLookup("password","tblPassword","password ='" & Me.text0 & "'")) Then
MsgBox "sorry"
End If
 
Dan,
Thank you for your reply, but the table has several
passwords in it. I want to confirm what is typed in the
text0 box against one of the records in the table.
Basically, just verifying that the password exists. Then
if it doesn't exist a message pops-up stating that they
have entered a wrong password.

TFTH,
Bill
 
Back
Top