Insert Into from Form fields?

[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

 

[Jeff Boyce]

Access forms don't hold data, Access tables do.

What are you trying to accomplish with the SELECT statement that refers to
forms...?

Regards

Jeff Boyce
Microsoft Office/Access MVP

 

[hor vannara]

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