debug error

T

T3E

hi can someone tell what is wrong with this coding i keep oon getting an
error message saying debug

If Me.password.Value = DLookup("Consultant_Password", "tblconsultant",
"[Consultant_ID]=" & Me.con.Value) Then
 
V

vbasean

hi can someone tell what is wrong with this coding i keep oon getting an
error message saying debug

If Me.password.Value = DLookup("Consultant_Password", "tblconsultant",
            "[Consultant_ID]=" & Me.con.Value) Then
Click to expand...

I don't see anything wrong with? are all the table and field names
correct? It also wouldn't hurt to put field names and table names in
brackets []
 
Top