Hey guys having some issues with copying 1 row from a table to another. I have this working on for another table but this one doesnt seem to work.
The Combobox "Coordinator" is the primary key and is a text box.
The error im getting is:
Run-time error '3061' Too few parameters, Expected 1
CODE
Private Sub Checkbox_AfterUpdate()
If Form_SubActionregWIP.Checkbox = True Then
CurrentDb.Execute "INSERT INTO tblactionregCOM ( Dateentered, Coordinator, Contact, Type, Workstation, Modelw, Asset, Serial, Software, ActionRequired, ActionTaken, Closedate) " & _
" SELECT Dateentered, Coordinator, Contact, Type, Workstation, Modelw, Asset, Serial, Software, ActionRequired, ActionTaken, Closedate " & _
" FROM tblActionreg " & _
" WHERE Coordinator = " & Me.Coordinator, dbFailOnError
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
End If
End Sub