remember current position

Hi,
I program VB with Ms Access database.
I open a Recordset and use MoveNext command. How do I remember my current record position and save it in an variable. Then use MoveNext or whatever to move to other record. Then I want to come back to the last record position that I store in an variable.

Thank
woainiAsked:
Who is Participating?
 
DalinConnect With a Mentor Commented:
Dim myBookmark as Variant
' setbookmark
myBookMark = recordset.bookmark

' Return
recordset.bookmark = myBookMark

Regards
0
 
woainiAuthor Commented:
It's perfect !!! Thank.
0
All Courses

From novice to tech pro — start learning today.