Login Form Compile Error

[abcrf]

I'm working with a preexisting database here, so forgive me if this seems a bit clumsy.

I'm trying to populate an entry in the table TBL_CURRENTUSER with the value of the record in the table TBLUSER that corresponds to the username/pass entered into the login form that this code applies to.

However, I am receiving the compile error "Sub or Function not defined. What am I doing wrong? The code in question is:

Update TBL_CURRENTUSER
  Set TBL_CURRENTUSER.UserName = DLookup("[USER NAME]", "TBLUSER", "USERLOGIN ='" & Me.txtPASSWORD.Value & "'")
  Set TBL_CURRENTUSER.USERLOGIN = Me.txtLOGINID
  Set TBL_CURRENTUSER.Password = Me.txtPASSWORD
  WHERE USERID = 1

 

[ozinm]

Almost.
You need one "Set" at the beginning.
The other 2 lines shouldn't have one.
also, the 2 lines need commas

have a quick look here for a brief description of the sql UPDATE synatx:
http://www.w3schools.com/sql/sql_update.asp