Search results

thank you for the input and suggestions from everyone in this forum, it turns out that the error that occurred came from me stating the first field was primary while the data I entered was detailed data, so only 1 record entered, after I removed the primary... .all data can be entered, thank you...

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.