im using the dlookup() to prievew password at a unbound textbox within a criteria that the username and security question that are entered matches the database.
Ex: user forget password.
he enters his user name, and select the security question, and answer the question.
if these data match the data in the tabels, then his password should be shown in the text box.

Me.passwordtxt.Value = DLookup("PASSWORD", "SYS_USER", "[USERNAME]=" & Me.usernametxt & " And[ANSWER]=" & Me.answertxt & "")

the error which comes is expression not match ? and tells me the username ??

any help will be very kind of you all, i tried working on this for two days, and posted many questions and didnt get accurate answers, any way thanks for any help in advance.

Votes + Comments
this is the 7th thread for the same question.
5 Years
Discussion Span
Last Post by BitBlt
This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.