3.3 Starting from the beginning

If you want to iterate through the whole table associated with a RecordSet, it is usually best to move the window to the beginning of the RecordSet. This is accomplished with the following statement:

myRecordSet.MoveFirst  
    

This is equivalent to pressing the “FirstRecord” button in the Datasheet View of a table.