CompareBookmarks Method
Compares two bookmarks and returns an indication of their relative values.
Syntax
result = recordset.CompareBookmarks(Bookmark1, Bookmark2)
Return Value
Returns a CompareEnum value that indicates the relative row position of two records represented by their bookmarks.
Parameters
Bookmark1 The bookmark of the first row.
Bookmark2 The bookmark of the second row.
Remarks
The bookmarks must apply to the same Recordset object, or a Recordset object and its clone. You cannot reliably compare bookmarks from different Recordset objects, even if they were created from the same source or command. Nor can you compare bookmarks for a Recordset object whose underlying provider does not support comparisons.
A bookmark uniquely identifies a row in a Recordset object. Use the current row's Bookmark property to obtain its bookmark.
A bookmark that is not valid or incorrectly formed will cause an error.