Moving to First and Last Rows

See Also

Quick Tour

Employee Form

To move to the first row of a dynaset, we use the DbMoveFirst method. We then call EmpRefresh() routine to refresh the data in the Employee form.

In our employee example, the First click event procedure looks like:

Private Sub cmdFirst_Click()

EmpDynaset.MoveFirst

Call EmpRefresh

End Sub

To move to the last row, we use the DbMoveLast method. We then call EmpRefresh() routine to refresh the data in the Employee form.

In our employee example, the Last click event procedure looks like:

Private Sub cmdLast_Click()

EmpDynaset.MoveLast

Call EmpRefresh

End Sub