Using Bookmarks
Bookmarks are used in ADO the same as ordinary bookmarks are used in books, to be able to find that place again later. This is especially useful when searching through a database or when using multiple tables. Use a Variant variable to store the bookmark.
rs.Open "Course", "Provider=PervasiveOLEDB;Data Source=Demodata", adOpenDynamic, adLockBatchOptimistic, adCmdTable
' navigate to the place you want to bookmark
SaveMyPlace = rs.Bookmark
' do some other things, then find your place again
rs.Bookmark = SaveMyPlace
rs.Close
Tip:
See Searching for Records for information on using the Find method.
Tip: See Searching for Records for information on using the Find method.