I use the following code to append individual records from the "Fis_Captur eT" table, to the "Fis_CaptDa taT" in realtime per row. It works 100%, until i correct an error in the "OrderQty" field, in the "Fis_Captur eT" table.
Code:
Dim MyDB As DAO.Database
Dim rstEntry As DAO.Recordset
Set MyDB = CurrentDb
Set rstEntry = MyDB.OpenRecordset("Fis_CaptDataT",