SQL statement error (1 Viewer)

[safeerbinsalih]

I want update one field in my recordset using UPDATE and WHERE command in SQL. But the following error is showing

strSQL = "UPDATE [tblLogin] SET [Login_password] = '"&Me.txtnewpassword&"' WHERE tblLogin.Login_id = '"&Me.txtLoginid&"'"
db.Execute strSQL, dbFailOnError

It is showing error "Compile error. Expected: End of statement" and highlighting the part "' WHERE tblLogin.Login_id = '"

Login_id is Long data type and Login_password is string

Any help is deeply appreciated

 

[Minty]

Remove the single quotes around txtloginID - it's a number not a string and put spaces between your & 's

WHERE tblLogin.Login_id = " & Me.txtLoginid &" ;"

 

[safeerbinsalih]

Thank you. It worked. Thank you for the info