runtime error??

[krc777]

I have the following line of code:

CurrentDb.Execute "INSERT INTO ChartTableC (ordernum, program) SELECT (" & kordernum & ", '" & kprogram & "') from trendanalysis"

I'm getting a runtime error - syntax error (comma) in query expression. I just don't see the problem.
m

 

[ByteMyzer]

What is the value of variable kprogram at the time that the error occurs?