MovePrev Method

Object List Next Object

Defined By: Dynaset

Description:

Moves to the previous record in the underlying database object. The CurrentRowNumber property is set to the Record (Row) that results from the Move method.

Declaration:

Function MovePrev() As Dynaset

Details:

Use the Move methods to navigate through your Dynaset by using code that is similar to using the corresponding buttons of the DataControl. Note that in using the buttons on the DataControl, however, the BOF and EOF properties will always be False since the DataControl will not allow you to extend beyond the RecordSet boundaries of the underlying database.

The MovePrev method will position the CurrentRecord at the previous available record in the underlying database. If you use MovePrev while positioned at the first record of the Dynaset, it sets the BOF property to True and the CurrentRecordNumber will be set to -1. Using MovePrev a second time also leaves the BOF value as True. In contrast, using MoveFirst more than once under these same conditions sets the CurrentRecordNumber to 0 and makes the first record the CurrentRecord.

See Also:

BOF property, EditMode property, EOF property, FindFirst, FindLast, FindNext, FindPrev methods, Update method