Run-time error '3061'

[TheLazyEngineer]

So I got some help here before for a runtime error that I was getting, well I'm back... now with a different error, after fixing a few others ones. I have no idea what this means. HELP please.

I have attached the actual access file if you would like to open it and check it out. The problem is with the "add" button, that adds the data I input into the table below it.
The error reads as you can see.
"Run-time error '3061':
Too few parameters. Expected 1."
Here is the code:
--------------------------------------------------------------------------

Private Sub cmdAdd_Click()
'add data to table
CurrentDb.Execute "INSERT INTO PROGRAM(programid, robotnumber, robot, box, options, origrom, [date], disk, customer) VALUES (" & Me.txtNumber & ",'" & Me.txtRobot & "','" & _
Me.txtBox & "', '" & Me.txtOptions & "', '" & Me.txtID & "', '" & 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

--------------------------------------------------------------------------
Here is the attached file. Any help would be appreciated. Thanks.

[June7]

When opening frmProgram, there are a bunch of popup prompts - the subform is not finding fields the controls reference. Why are form and subform bound to the same data? Maybe you should consider Split Form object.

These are bound forms. Why are you using code to insert a record? If you set the controls to "" then you are changing data in the current record.


Advise not to use spaces and special characters/punctuation (underscore is exception) in naming convention. Also, don't use reserved words as names - Date is a reserved word.