The Recordset object's Move method allows you to move the cursor to another position relative to either the current position, or that specified by a Bookmark. The Move method provides two arguments:
rst.Move rows[, start]
The rows argument specifies the number of rows to move, and the direction: greater than zero indicates forward, less than zero means backward. The optional start argument specifies where to start the move from. When you supply a Bookmark for the start argument, DAO moves the cursor the appropriate number of rows from the position specified by the Bookmark. If you omit the start argument, DAO moves the cursor from the current position.
In ForwardOnly recordsets, the rows argument must be greater than zero, and you cannot specify a Bookmark.
Was this article helpful?