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",
...