The right syntax should be something like:
INSERT INTO Custorder (job_order) VALUES (123)
or, in case of alfanumeric values:
INSERT INTO Custorder (job_order) VALUES ('abc')
so your code should be something like:
sqlstr = "INSERT INTO Custorder (job_order) VALUES (" & Jobno & ");"
or
sqlstr = "INSERT INTO Custorder (job_order) VALUES ('" & Jobno & "');"
hope this helps....
"Daniel Tan" <da*******@time.net.my> wrote in message
news:6a*************************@posting.google.co m...
I got a syntax error in SQL insert into statement , hope someone can
help me .Thanks.
job_search = "[job_order]='" & Me.Jobno & "' "
sqlstr = "INSERT INTO Custorder (job_order) " & _
"values " & (job_search) & ";"
Regards,
Daniel