See Also Example
Applies To
Table object, Dynaset object, Snapshot object.
Description
Determines which record in a recordset is the current record. Not available at design time; read/write at run time.
Syntax
recordset.Bookmark [ = variable ]
Remarks
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 statement.
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 String or Variant data type. The length of the string cannot be predicted, so if you use a string variable, do not use a fixed-length string.