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