DoCMD Update problems

[bbwolff]

 If Me.txtPassword.Value = DLookup("UPass", "Users", "[UserID]=" & usID) Then
  
  user = Me.txtUName.Value
newpass= Me.txtPassNew.Value

  DoCmd.RunSQL "Update  Users set Upass=newpass where Uname=user"
  End If

why is this routine asking me for values for user and newpass.
it's the same if i use the variable or just values of the textboxes

 

[pbaldy]

You have to concatenate the values into the string, similar to the DLookup criteria.

 

[bbwolff]

like this?

 DoCmd.RunSQL "Update  Users set Upass='" & Me.txtPasswordNew.Value & "' where Uname='" & Me.txtUName.Value & "'"

 

[pbaldy]

If it works, yes.

 

[bbwolff]

had some other problems so it looked like it didn't work, fixed it now, tx

 

[pbaldy]

No problem.