Help with macro syntax error


Attempting to populate a filter table with a variable. The enclosed code works if I update the table with an integer, but does not like the variable.
Thanks for your help


You are making &invno part of the SQL statement. What you need:

SQL = "UPDATE ""tFilter"" SET ""jobid"" = '" & invno & "'"

Another example (a Select statement) here → Sql within a base macro using variables gives syntax error

Hmm - isn’t there a missing " after tFilter and it should read:

SQL = "UPDATE ""tFilter"" SET ""jobid"" = '" & invno & "'"


Yes! Thank You Very Much! Will correct. Did not need to delete your ans. was going to delete mine. Just a timing thing.

Thank you very much! Appreciated.