Button form/subform add/remove first 100 records

[joaofigu]

Hi there,


i have a Form that reads a subform from a table , and i have a field Yes/No, i woul like to add a bitton in a form tha selects the first 100 records( for example) and if i click agaian add more 100 and another do remove 100 each time.

can somebody help me?

Thanks.

[Uncle Gizmo]

This doesn't come up very often but when it does you will probably find it under the search term "pagination"

Sent from my Pixel 3a using Tapatalk

[joaofigu]

Thanks, i will search for this!!.

i ve already something like this:

Dim rs As DAO.Recordset


Set rs = Me!SFrm_Contentor.Form.RecordsetClone


While Not rs.EOF
rs.Edit
rs!GoYesNo.Value = True
rs.Update
rs.MoveNext
Wend


Set rs = Nothing