MovePrevious Method

The MovePrevious method on a Recordset object moves to the previous record in a specified Recordset object and makes that record current.

recordset.MovePrevious
 

Parameters

None.

Remarks

The MovePrevious method is used to move the current record position one record backward (toward the top of the recordset). If the Recordset object does not support either bookmarks or backward cursor movement, the MovePrevious method generates an error.

If the first record is the current record and the MovePrevious method is invoked, ADO sets the current record to the position before the first record in the recordset (the BOF property is set to True). An attempt to move backward when the BOF property is already True generates an error.

Note that if a MovePrevious method is invoked after Delete method is invoked, this moves the current record back two records instead of one.