Moving to the Previous Row

We can position ourselves on any row of a dynaset. When positioned in the middle of a dynaset (current row is not the first row), we navigate to the previous row using DbMovePrevious.

However, when we are positioned on the first row (current row is the first row) and then execute DbMovePrevious, the beginning-of-file (BOF) condition becomes TRUE and the current row becomes invalid. In this case, we reset the current row to the first row using DbMoveFirst.

The click event procedure for our Previous button looks like:

Private Sub cmdPrevious_Click()

EmpDynaset.MovePrevious

If EmpDynaset.BOF = True Then

MsgBox WarnFirstEmp$

EmpDynaset.MoveFirst

End If

Call EmpRefresh

End Sub