debug error

[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

 

[NetworkTrade]

your message stops at the Then

 

[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

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 []