Use Variable IN Update Statement

[chalupabatman]

Good day - I am attempting to use variables in my VBA Update statement, but I can't get the syntax accurate. This is what I have, but is incorrect. Can someone show me how this syntax should be set-up?

Dim on As String, jn As String, sm As String, pn As String
on = "Red"
jn = "Mike"
sm = "Total"
pn = "Highlife"
DoCmd.RunSQL ("UPDATE ET SET [jn] = jn,[on] = on,[sm] = sm,[pn] = pn")

[knarfreppep]

Good day - I am attempting to use variables in my VBA Update statement, but I can't get the syntax accurate. This is what I have, but is incorrect. Can someone show me how this syntax should be set-up?

Dim on As String, jn As String, sm As String, pn As String
on = "Red"
jn = "Mike"
sm = "Total"
pn = "Highlife"
DoCmd.RunSQL ("UPDATE ET SET [jn] = jn,[on] = on,[sm] = sm,[pn] = pn")

DoCmd.RunSQL "UPDATE ET SET jn = '" & jn & "', on = '" & on & "', sm = '" & sm & "', pn = '" & pn & "'"

[orange]

Try (untested)

Dim on As String, jn As String, sm As String, pn As String
on = "Red"
jn = "Mike"
sm = "Total"
pn = "Highlife"

Debug.print "UPDATE ET SET [jn] = '" & jn  & "',[on] ='" &  on &  "',[sm] = '" & sm & "',[pn] = "" &  pn

DoCmd.RunSQL ("UPDATE ET SET [jn] = '" & jn  & "',[on] ='" &  on &  "',[sm] = '" & sm & "',[pn] = "" &  pn)

Why 2 character names?
Always do a debug print before executing action queries to ensure Access is rendering the SQL you expect. Check for errors.
Action queries can be very unforgiving.