Syntax error on insert statement

[rcsmith0712]

Hi Folks. I have a simple insert statement only four fields. The last field "Table" is the problem child. IF I take it out and the associated value "Me.txtTemp Tab" the insert statement works. Image of code also attached. Any assistance would be greatly appreciated. Thank you in advance...

DoCmd.RunSQL "INSERT INTO tblScrBldSched " & _
"( OrderNo, Tech, SchedDate, Table )" & _
"VALUES ('" & Me.cmbSTBT1A.Column(0) & "' ," & _
" '" & Me.cmbScrTechT1A.Column(0) & "' ," & _
" '" & Me.txtSchedDate & "' ," & _
" '" & Me.txtTempTab & "' );"

[ADezii]

First, try a couple of minor adjustments:

DoCmd.RunSQL "INSERT INTO tblScrBldSched " & _
             "([OrderNo], [Tech], [SchedDate], [Table])" & _
             " VALUES ('" & Me.cmbSTBT1A.Column(0) & "' ," & _
             "'" & Me.cmbScrTechT1A.Column(0) & "' ," & _
             "'" & Me.txtSchedDate & "' ," & _
             "'" & Me.txtTempTab & "');"

[rcsmith0712]

Thanks ADezii. That worked! Though I'm not sure why the brackets are needed in this case. Can you help me understand why?

[cactusdata]

The brackets are only needed for reserved words and names with spaces or weird characters.
Also, a date value should be inserted as a string expression for the date value, not as text, thus:

DoCmd.RunSQL "INSERT INTO tblScrBldSched " & _
"( OrderNo, Tech, SchedDate, [Table] ) " & _
"VALUES ('" & Me.cmbSTBT1A.Column(0) & "', " & _
"'" & Me.cmbScrTechT1A.Column(0) & "', " & _
"#" & Format(Me!txtSchedDate.Value, "yyyy\/mm\/dd") & "#, " & _
"'" & Me.txtTempTab & "');"