Bookmark Property

See AlsoproBookmarkSee                 ExampleproBookmarkX>Low

Applies To

Table object5RHH0MW, Dynaset object25TLT8, Snapshot objectHBYSUX.


Determines which record in a recordset22S7WAF is the current record1BNJB8X.  Not available at design time; read/write at run time.


recordset.Bookmark [ = variable ]


When a recordset is created or opened, each record already has a unique bookmark.  You can save the bookmark for the current record by assigning the value of the Bookmark property to a variable.  To quickly return to that record at any time after moving to a different record, set the recordset's Bookmark property to the value of that variable.

To make sure the recordset supports bookmarks, inspect the value of the Bookmarkable property before you use the Bookmark property.  If Bookmarkable is False, the recordset doesn't support bookmarks.

Between a Dynaset and a duplicate Dynaset created with the Clone method, the bookmark values are identical and can be used interchangeably.  You cannot use bookmarks from different Dynasets, even if they are created from the same table or with the same SQL statement29F05E5.

A bookmark may become invalid if the underlying record is deleted by another user.

The value of the Bookmark property is not the same as a record number.

Data Type

The value is a string of binary data, but can be stored in a variable of String7WSH0XQ or Variant2ZCGYKB data type.  The length of the string cannot be predicted, so if you use a string variable, do not use a fixed-length string.