MoveNext Method

Object List Next Object

Defined By: Dynaset

Description:

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

Declaration:

Function MoveNext() 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 MoveLast method will position the CurrentRecord at the last record in the underlying database. If you use MoveNext at the last record of the Dynaset, it sets the EOF property to True. The CurrentRecordNumber will be set to the last record number + 1. Using MoveNext a second time leaves the EOF value as True. In contrast, using MoveLast more than once under these same conditions sets the CurrentRecordNumber to the last record number and makes the last record the CurrentRecord.

When you open a Dynaset with at least one record, the first record is considered current and the BOF property is False. If there are no records in the Dynaset, BOF and EOF are both True, and no record is considered current.

See Also:

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