I'm trying to transfer records from a table in one subform to another subform (on same form) using a checkbox as a filter:
Expand|Select|Wrap|Line Numbers
- 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
The Main form is: [Extra Work Report Checksheet]
Subforms are: [Equipment Input Subform1] & [Equipment Checksheet Table Subform]
Checkbox field is: [EquipmentUsed]
I keep getting the error "Syntax error in INSERT INTO statement" which points to 'db.Execute strSQL, dbFailOnError' and I don't understand why. Neither of the fields [QuanityUsed] or [HoursUsed] are lookup fields, etc. Could someone please help out.
Thank you
ajochung is online now Add to ajochung's Reputation Report Post