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.

---