ADO: ActiveX Data Objects

Name

Recordset.MoveFirst Method — RMF Method(Versions 2.0, 2.1, 2.5, 2.6)

Recordset.MoveLast Method — RML Method(Versions 2.0, 2.1, 2.5, 2.6)

Recordset.MoveNext Method — RMN Method(Versions 2.0, 2.1, 2.5, 2.6)

Recordset.MovePrevious Method — RMP Method(Versions 2.0, 2.1, 2.5, 2.6)

Synopsis

                     recordset.MoveFirst
recordset.MoveLast
recordset.MoveNext
recordset.MovePrevious

The MoveFirst, MoveLast, MoveNext, and MovePrevious methods of the Recordset object move the record pointer to the first, last, next, and previous records, respectively, and make that record the current record.

Description

The MoveFirst, MoveLast, MoveNext, and MovePrevious methods of the Recordset object allow you to move freely throughout the specified open Recordset object.

The MoveFirst method moves to the first record in the recordset, making it the current record.

The MoveLast method moves to the last record in the recordset, making it the current record. This method requires the Recordset object to support bookmarks. If it does not, an error is generated when attempting to use the MoveLast method.

The MoveNext method moves to the next record in the recordset, making it the current record. If the current record is the last record in the recordset before the call to MoveNext, then the record pointer is moved to the record after the last in the recordset and sets the EOF property to True. Attempting to move past the EOF results in an error.

The MovePrevious method moves to the record directly before the current record in ...