ADO Move Method


❮ Complete Recordset Object Reference

The Move method moves the record pointer in a Recordset object.

Note: This method can be used on all Recordset objects.

Syntax

objRecordset.Move numrec,start

Parameter Description
numrec Required. Specifies how many records the record pointer will move.

Example: If this parameter is set to 3, the record pointer moves 3 records forward.

Example: If this parameter is set to -3, the record pointer moves 3 records backward

start Optional. Where to start. Can be a bookmark or a BookmarkEnum value

BookmarkEnum

Constant Value Description
adBookmarkCurrent 0 Starts at the current record
adBookmarkFirst 1 Starts at the first record
adBookmarkLast 2 Starts at the last record

❮ Complete Recordset Object Reference
Copyright 1999-2023 by Refsnes Data. All Rights Reserved.