Mr Alex, actually my comment was a follow up with my first question, which was about the recordset Rs.movenext that it wont skip records and its only skip one record as a click the button. So i replied yes it wont skip records and i use Access 2016. So is there a way to fix this issue? I just want to skip record by record as a click a button. Thanks.

---

Reply from Alex Hedley:

I usually have a
If NOT rs.EOF Then rs.MoveFirst

Looping

Do While Not rst.EOF
    'Work with your recordset
    rst.MoveNext
Loop