S
stvlai
Hi
I have a Form F1, Table T1 & T2, Fields F1, F2, F4, F5. T1 is
actually a SQL Table and it belongs to another Database. I am trying
to retrieve selective records from the SQL and place it in an Access
DB. I knows this sound kind of redundant but I need some info how to
do this.
If I use the Insert Into command, can I reference the field in the
form instead of a query (modify the Append query)? e.g
INSERT INTO tbl_T2 (Order_id, Serial_no, RMA_No)
SELECT [Forms]![F1].order_id, [Forms]![F1].Rma_No
FROM [Forms]![F1];
Any info would be very much appreciated. Thanks
Lai
I have a Form F1, Table T1 & T2, Fields F1, F2, F4, F5. T1 is
actually a SQL Table and it belongs to another Database. I am trying
to retrieve selective records from the SQL and place it in an Access
DB. I knows this sound kind of redundant but I need some info how to
do this.
If I use the Insert Into command, can I reference the field in the
form instead of a query (modify the Append query)? e.g
INSERT INTO tbl_T2 (Order_id, Serial_no, RMA_No)
SELECT [Forms]![F1].order_id, [Forms]![F1].Rma_No
FROM [Forms]![F1];
Any info would be very much appreciated. Thanks
Lai