For the life of me I can't figure this out

I'm trying to transfer records from a table in one subform to a table in another subform (same form) using a checkbox as a filter:

Private Sub TransferAndReview_Click()
Dim db As dao.Database
Dim strSQL As String

strSQL = "INSERT INTO Forms![Extra Work Report Checksheet]![Equipment Input Subform1].Form[(QuantityUsed[, HoursUsed])] VALUES (QuantityUsed[, HoursUsed]) FROM Forms![Extra Work Report Checksheet]![Equipment Checksheet Table Subform] WHERE [Extra Work Report Checksheet]![Equipment Input Subform1].Form[EquipmentUsed]=True;"

Set db = CurrentDb
db.Execute strSQL, dbFailOnError

End Sub

In this case:
The main form is [Extra Work Report Checksheet]

Subforms are [Equipment Input Subform1] & [Equipment Checksheet Table Subform]

And the Checkbox field is [EquipmentUsed]

I keep getting an error that "There is a syntax error in INSERT INTO statement" which points to 'db.Execute strSQL, dbFailOnError' and I have no idea why. Could someone please let me know.

Thank you