Run-time error '3061' Too few parameters, Expected 1

[prawln]

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

[June7]

Is Coordinator number or text datatype? If is text field enclose the variable with apostrophe delimiters. Otherwise, can't see anything wrong with code.

" WHERE Coordinator = '" & Me.Coordinator & "'", dbFailOnError