Add Data to second table

[elaineva]

I have 2 tables that need a new po nr added. So I made a form adding the Po nr to table 1 but I'm not sure how to add the new po nr to table 2 without rekeying. Do I use update, addnew, insert??? I would like to go the easy route as I'm not good with vb.

 

[SQLBI]

Elaine,

Try append query.

INSERT INTO tblTable2
SELECT *
FROM tblTable1
WHERE PONr = [Enter PO Number.]

Hope this helps.

Leigh Moore
LJM Analysis Ltd

http://www.ljm-analysis.co.uk