Bookmark

This property specifies a bookmark that uniquely identifies a record in a recordset.

Syntax

recordset.Bookmark [= value]

Parameters

object

Object expression that is an object.

value

Variant expression that is a bookmark.

Return Values

Returns a Variant expression that is a valid bookmark.

Remarks

Use the Bookmark property to save the position of the current record and return to that record at any time.

When you open a Recordset object, each record has a unique bookmark. To save the bookmark for the current record, assign 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 Bookmark property to the value of that variable.

If you use the Clone method to create a copy of a Recordset object, the Bookmark property settings for the original and the duplicate Recordset objects are identical, and you can use them interchangeably. However, you cannot use bookmarks from different Recordset objects interchangeably, even if they were created from the same source or command.