I have the following lines in a macro:
sql = "INSERT INTO IM (ITEM, DESC) VALUES (vitem, ndesc)"

DoCmd.RunSQL sql

Every time I execute the macro, I get a run time error saying there is a
syntax error in the INSERT INTO command. I have tried numerous variations
with the same result.

I would greatly appreciate anybody's help in pointing me in the right
direction.

John Cantlin

What are vitem and ndesc? Are they variables in your code? If yes,
concatenate their values into the string:

sql = "INSERT INTO IM (ITEM, DESC) VALUES (" & vitem & ", " & ndesc & ")"


--

Ken Snell
<MS ACCESS MVP>


<jpcantlin (AT) cox (DOT) net> wrote

For troubleshooting SQL errors like this, put a "debug.print sql"
statement in your code, right after you've completed building your sql
string. Put in a breakpoint after that. Now you can lift the sql
statement from the immediate window and examine it for syntax errors.
You can also paste it inot SQL Query Analyzer and execute the statement.

Ken Snell wrote: