Help with Insert Into Error

[mdiaz]

I created this form that users can enter data into and click on a button to add the data to a table. I can not seem to find the issue. Each time I run it i get the Run-Time error '3134' Syntax error in INSERT INTO statement. The code is below any help will be appreciated.

Private Sub cmdAdd_Click()
'add data to table
CurrentDb.Execute "INSERT INTO Production(Date of Data, New Referrals 1st Stage, New Referrals 2nd Stage, Email Submatters, Query Submatters, BK Referrals, Evictions, Military Searches Completed, Military Searches Follow Up, Missing Document Follow Up, Transfer Foreclosure Referrals, Transfer DE - FO FIle Opened)" & _
" VALUES(" & Me.cbodate & ",'" & Me.txtnr1 & "','" & Me.txtnr2 & "','" & Me.txtemail & "','" & _
Me.txtquery & "','" & Me.txtbky & "','" & Me.txteviction & "','" & Me.txtmilcomp & "','" & Me.txtmilfu & "','" & _
Me.txtmissingdoc & "','" & Me.txttransferfc & "','" & Me.txttransferde & "')"

'refresh data in list on form
frmproductionsub.Form.Requery
End Sub

[pbaldy]

This should help:

http://www.baldyweb.com/ImmediateWindow.htm

Offhand, the inadvisable spaces and symbols in field names require the names to be bracketed and the date value would need to be surrounded by #.

[mdiaz]

Sorry i am fairly new to this could you point out where i need to make the changes?

[pbaldy]

What were the results of the Debug.Print? Have you added brackets to your field names?

[Date of Data]

[mdiaz]

Your awesome it worked, thanks for your help.

[pbaldy]

No problem, and welcome to the site by the way!