These methods respectively move to the first, last, next, or previous record in a specified Recordset object, making that record the current record.
recordset.MoveFirst
recordset.MoveLast
recordset.MoveNext
recordset.MovePrevious
Use the MoveFirst method to move the current record position to the first record in the recordset.
Use the MoveLast method to move the current record position to the last record in the recordset.
Use the MoveNext method to move the current record position one record forward, toward the bottom of the Recordset. If the last record is the current record and you call the MoveNext method, ADOCE sets the current record to the position after the last record in the Recordset — EOF is True. An attempt to move forward when the EOF property is already True generates an error.
Use the MovePrevious method to move the current record position one record backward, toward the top of the Recordset. If the first record is the current record and you call the MovePrevious method, ADOCE sets the current record to the position before the first record in the Recordset — BOF is True. An attempt to move backward when the BOF property is already True generates an error.