我试图在一张叫做“tbl_Responses”的表格中更新几个栏目,
varX= DLookup("[ID]", tableName, "[supplierNum] = " & supplierNum)
updateFieldsTbl1="column1,column2,column3,column4"
updateValuesTbl1 ="name,lastname, bla bla"
There is nothing wrong with those 3 variables above.
sqlUp = "UPDATE " & tableName & "(" & updateFieldsTbl1 & ")" & " SET " & "(" & _ updateValuesTbl1 & ") WHERE ID = " & varX
DoCmd.RunSQL sqlUp
It gives an error in UPDATE statement line. Can you please tell what I am doing wrong? Thanks in advance