N
Noemi
Hi
I have the code below for a query and I would like to add this into the
coding of a form so the query is run once a button is selected.
Can someone please help with how I need to convert this into an appropriate
code so the 1st table is updated and saved, then the query is run which takes
the key thing from the first table (which is an auto number) and adds it inot
the 2nd table so we can link the 2 rables together
INSERT INTO Tbl_BuyersAuthorityKC ( Keycode, Style, Description, Net, GST,
Total, Quantity )
strQuery = SELECT Tbl_BuyersAuthorityKC_Temp.Keycode,
Tbl_BuyersAuthorityKC_Temp.Style, Tbl_BuyersAuthorityKC_Temp.Description,
Tbl_BuyersAuthorityKC_Temp.Net, Tbl_BuyersAuthorityKC_Temp.GST,
Tbl_BuyersAuthorityKC_Temp.Total, Tbl_BuyersAuthorityKC_Temp.Melb
FROM Tbl_BuyersAuthorityKC_Temp
Thanks
Noemi
I have the code below for a query and I would like to add this into the
coding of a form so the query is run once a button is selected.
Can someone please help with how I need to convert this into an appropriate
code so the 1st table is updated and saved, then the query is run which takes
the key thing from the first table (which is an auto number) and adds it inot
the 2nd table so we can link the 2 rables together
INSERT INTO Tbl_BuyersAuthorityKC ( Keycode, Style, Description, Net, GST,
Total, Quantity )
strQuery = SELECT Tbl_BuyersAuthorityKC_Temp.Keycode,
Tbl_BuyersAuthorityKC_Temp.Style, Tbl_BuyersAuthorityKC_Temp.Description,
Tbl_BuyersAuthorityKC_Temp.Net, Tbl_BuyersAuthorityKC_Temp.GST,
Tbl_BuyersAuthorityKC_Temp.Total, Tbl_BuyersAuthorityKC_Temp.Melb
FROM Tbl_BuyersAuthorityKC_Temp
Thanks
Noemi