INSERT INTO Statement Syntax Error Message

[jgroh9]

When I try to run the following Append Query I keep getting error message 3075. "Syntax Error(missing operator) in query expression.

Here is the code:
DoCmd.RunSQL "INSERT INTO tblErrors ( ErrorNumber, ErrorDescription ) VALUES(" _
& " '" & strErrNum & "', '" & strErrDesc & "' )"

Does anyone know what the problem might be?

Thanks

 

[jrbarnett]

What is in the "strErrNum" and "strErrDesc" variables?
Are they the correct data type for the underlying table and not null?

John

 

[vbajock]

Dim Sql as string

Assign
"INSERT INTO tblErrors ( ErrorNumber, ErrorDescription ) VALUES(" _
& " '" & strErrNum & "', '" & strErrDesc & "' )"

to variable sql

DoCmd.RunSQL sql

when you get the error, goto the immediate window, and type
?sql
You'll see what your passing to the SQL engine. You should see the error.