Insert data from table and form

[Guest]

I need to insert data into Table1 from Table2 and the Main form. Here's the
scenerio: I need to insert into Table1 fields: ForecastID, PartNumber,
Quantity.
ForecastID is obtained from the Main form's txtForecastID textbox.
PartNumber and Quantity are both from Table2.

This is what I have so far:
sql = "INSERT INTO Table1 (PartNumber, Quantity) "
sql = sql & " SELECT [PartNumber], [Quantity] FROM Table2 "

But I'm not sure how I can include txtForecastID in the sql statement.
Thanks in advance.

 

[Guest]

Try something like ...

sql = "INSERT INTO Table1 (PartNumber, Quantity, ForecastID) "
sql = sql & " SELECT [PartNumber], [Quantity], " & Me!txtForecastID & " as
Fid FROM Table2 "

 

[Guest]

I see! Thank you very much Chris!