Hi, what am i doing wrong?
DoCmd.RunSQL "INSERT INTO TableA([FIELD1],[FIELD2]) VALUES ('" & [TempVars]![val1] & "'& ", " & '" & [TempVars]![val2] & "')"
i want to update a table with 2 tempvars values, but get me error 2498
val1 = 10000124
val2 = 2019/09/10 10:10:11
thanks
DoCmd.RunSQL "INSERT INTO TableA([FIELD1],[FIELD2]) VALUES ('" & [TempVars]![val1] & "'& ", " & '" & [TempVars]![val2] & "')"
i want to update a table with 2 tempvars values, but get me error 2498
val1 = 10000124
val2 = 2019/09/10 10:10:11
thanks