I've put that code in. It does append correctly but does not open the form on the appended record.
Here is the debug.print showing correct information:
Code:
INSERT INTO Invoice_Entries ( On_Issue, Order_ID, TypeOfInvoice, Doc_Code, Import_Code ) SELECT Order_Tbl.Invoice_Issue, Order_Tbl.Order_ID, '1' AS invoice, '_INV' AS Expr2, 'SI' AS Expr1 FROM Order_Tbl WHERE (((Order_Tbl.Order_ID)= 121));
1157
INSERT INTO Invoice_Entries ( On_Issue, Order_ID, TypeOfInvoice, Doc_Code, Import_Code ) SELECT Order_Tbl.Invoice_Issue, Order_Tbl.Order_ID, '1' AS invoice, '_INV' AS Expr2, 'SI' AS Expr1 FROM Order_Tbl WHERE (((Order_Tbl.Order_ID)= 121));
1146
INSERT INTO Invoice_Entries ( On_Issue, Order_ID, TypeOfInvoice, Doc_Code, Import_Code ) SELECT Order_Tbl.Invoice_Issue, Order_Tbl.Order_ID, '1' AS invoice, '_INV' AS Expr2, 'SI' AS Expr1 FROM Order_Tbl WHERE (((Order_Tbl.Order_ID)= 121));
1147
Here is the one using the code provided by yourself with "gotolast" disabled.
With the code currently in use:
I wouldnt know where to begin with this, I shall do some reading.
Andy.