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.

debasisdas commented: this is the 7th thread for the same question. -3