Hello All,
I'm having trouble using a union function with "insert into" function.
Maybe what I'm trying to do is not possible
Thanx for the help!
Farris
INSERT INTO [temp order_tbl] ( [part no], [part type], cost)
SELECT [model no], productdescription, unitprice
FROM model_tbl
WHERE [model no] = (forms![main_frm]![computer_lbx].Value)
UNION
INSERT INTO [temp order_tbl] ( [part no], [part type], cost)
SELECT [display no], productdescription, unitprice
FROM display_tbl
WHERE [display no] = (forms![display_frm]![displayList_lbx].Value);