Using DoCmd.RunSQL in Forms to write data to table

[dandoescode]

Hey, just started dealing with forms, and I'm attempting to write data gathered in a form to a table, seems like it should be pretty simple, but I keep getting an error.



DoCmd.RunSQL ("UPDATE tblPersonnel SET tblPersonnel.txtPassword =" & newPass & "WHERE tblPersonnel.tblPersonnelID =" & userID & ";")

The table name is tblPersonnel, I'm attempting to alter txtPassword for a user from their input newPass. The error is 3075, Syntax error (missing operator) in query expression '1WHERE tblPersonnel.tblPersonnelID= 435'

Note 435 is just the userID value for the particular case

[orange]

Since txtPassword is a string you need quotes around newPass.

and you need a space before the "WHERE..."
Try
DoCmd.RunSQL ("UPDATE tblPersonnel SET tblPersonnel.txtPassword ='" & newPass & "' WHERE tblPersonnel.tblPersonnelID =" & userID & ";")

[dandoescode]

Thanks for the speedy response! That fixed it right up.