Update query in code syntax help

[Alex]

I'm trying to do an update in code but my syntax is wrong. Can someone tell
me how I'm writing this incorrectly? Thanks.

CurrentDb.Execute "UPDATE AllNewParts SET AllNewParts.RefPartEAU =
ExcelARefParts.Annual Qty" _
& "WHERE (((AllNewParts.RefPart) = ExcelARefParts.AS Part# AND
(AllNewParts.RefPartNHL) = ExcelARefParts.As Part# And
(ExcelARefParts.Model#) = AllNewParts.Model#));"

 

[Allen Browne]

You must use square brackets around the field names that contain a space, #,
or any other characters that are not a digit, letter, or underscore (and
also if the field name starts with a digit.)

You were also missing a space before the WHERE.

CurrentDb.Execute "UPDATE AllNewParts SET AllNewParts.RefPartEAU =
ExcelARefParts.[Annual Qty]" _
& " WHERE (AllNewParts.RefPart = ExcelARefParts.[AS Part#]) AND
(AllNewParts.RefPartNHL = ExcelARefParts.[As Part#]) AND
(ExcelARefParts.[Model#] = AllNewParts.[Model#]);"