3.5 Moving to the next record (row)

After you process one record, you probably want to move to the next record, like pressing the “Next Record” button in the Datasheet View of a table. In VBA, this is accomplished by the following statement:

myRecordSet.MoveNext