Password verification

[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

 

[Dan Artuso]

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

 

[Bill]

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