brucemc777
Member
- Local time
- Yesterday, 20:06
- Joined
- Nov 1, 2012
- Messages
- 88
I obtained the following SQL from an Append query in Access:
INSERT INTO tblOrderEquipment ( IDOrderEquipment, IDEquipment, IDOrders, UnitCount )
SELECT tblOrderEquipment.IDOrderEquipment, tblOrderEquipment.IDEquipment, tblOrderEquipment.IDOrders, tblOrderEquipment.UnitCount
FROM tblOrderEquipment
WHERE (((tblOrderEquipment.IDEquipment)=Forms!frmEquipOrder!frmOrderAddEquip.Form!cbxEquipSelect.Column(0)) AND ((tblOrderEquipment.IDOrders)="IDOrders") AND ((tblOrderEquipment.UnitCount)="tbCount"));
and i'm attempting to run it from a command button as follows:
But i get an error:
I also noted when Forms!frmEquipOrder!frmOrderAddEquip.Form!cbxEquipSelect.Column(0) was run in the immediate window i got back the result i am looking for. Apparently there is more to converting an SQL statement from an Append Query than cut & paste-
By looking at the above can anyone tell me what needs to be modified and perhaps how?
Thank you very much for helping me learn and dealing with my confusion!
-Bruce
INSERT INTO tblOrderEquipment ( IDOrderEquipment, IDEquipment, IDOrders, UnitCount )
SELECT tblOrderEquipment.IDOrderEquipment, tblOrderEquipment.IDEquipment, tblOrderEquipment.IDOrders, tblOrderEquipment.UnitCount
FROM tblOrderEquipment
WHERE (((tblOrderEquipment.IDEquipment)=Forms!frmEquipOrder!frmOrderAddEquip.Form!cbxEquipSelect.Column(0)) AND ((tblOrderEquipment.IDOrders)="IDOrders") AND ((tblOrderEquipment.UnitCount)="tbCount"));
and i'm attempting to run it from a command button as follows:
Code:
Private Sub cbAdd_Click()
Dim SQL As String
SQL = "INSERT INTO tblOrderEquipment ( IDOrderEquipment, IDEquipment, IDOrders, UnitCount )" _
& "SELECT tblOrderEquipment.IDOrderEquipment, tblOrderEquipment.IDEquipment," _
& "tblOrderEquipment.IDOrders, tblOrderEquipment.UnitCount FROM tblOrderEquipment" _
& "WHERE (((tblOrderEquipment.IDEquipment)=Forms!frmEquipOrder!frmOrderAddEquip.Form!cbxEquipSelect.Column(0))" _
& "AND ((tblOrderEquipment.IDOrders)=""IDOrders"") AND ((tblOrderEquipment.UnitCount)=""tbCount""));"
DoCmd.RunSQL SQL
End Sub
But i get an error:
I also noted when Forms!frmEquipOrder!frmOrderAddEquip.Form!cbxEquipSelect.Column(0) was run in the immediate window i got back the result i am looking for. Apparently there is more to converting an SQL statement from an Append Query than cut & paste-
By looking at the above can anyone tell me what needs to be modified and perhaps how?
Thank you very much for helping me learn and dealing with my confusion!
-Bruce