runtime error 3134

Hey, I'm new here and new to access. I'm trying to set up a simple database for my company that I can keep track of the programs we write, and the customer we write them for, etc...

I'm having this recurring error with my code and I have no idea why it's happening, I have looked at pretty much every resource to no avail.



The error is

"Run-time error '3134':

Syntax error in INSERT INTO statement."



Here is my code, any help would be very appreciated, thanks!

(I attempted to highlight the code that is giving me the error)

---------------------------------------------------------------------------------------

Private Sub cmdAdd_Click()

'add data to table

CurrentDb.Execute "INSERT INTO PROGRAM(programid, programnum, robot, box, options, origrom, date, disk, customer) VALUES (" & Me.txtID & ",'" & Me.txtRobot & "','" & _ Me.txtBox & "'.'" & Me.txtOptions & "'.'" & Me.txtRom & "'.'" & Me.txtDate & _ "'.'" & Me.txtDisk & "'.'" & Me.txtCustomer & "')"

'refresh data in list on form

frmProgramSub.Form.Requery



End Sub



Private Sub cmdClear_Click()

Me.txtNumber = ""

Me.txtRobot

Me.txtBox

Me.txtOptions

Me.txtRom

Me.txtDisk

Me.txtCustomer

Me.txtDate



Me.txtID.SetFocus

End Sub



Private Sub cmdClose_Click()

DoCmd.Close



End Sub



Private Sub txtID_Click()



End Sub

---------------------------------------------------------------------------------------

runtime error 3134