Read forward in recordset without moving current record? (1 Viewer)

[DocNice]

Hey all,
I could swear I've seen a way to read the contents of the next record without actually telling the recordset to movenext. Like a +1, +2 type of thing. But I can't find it now.

Can this be done and what is the language?
Thanks,
Doc

 

[RuralGuy]

You can use the RecordSetClone. Referring to a Field in the Previous Record or Next Record

 

[Bodisathva]

you can reference the absolutePosition property of the recordset...that will tell you the exact location, calculated from the beginning, of the record you are currently on, so as long as you don't change your recordset data, you can move back directly.