Search results

hi, im try to save all record on subform to tabel but only first record saved, an this my code : Public Sub DetailSaved() Dim Rs As DAO.Recordset Dim subFrm As Access.Form Set subFrm = Me.[FTSLIPSEC].Form Set Rs = subFrm.RecordsetClone Do While Not Rs.EOF CurrentDb.Execute "INSERT INTO...

i hope in this forum i can get more knowledge for access, thanks for admin and all friends in here, thanks a lot.