Here is (IMHO) better code for moving Previous/Next:
Code:
Private Sub cmdPrior_Click()
On Error GoTo HandleIt
DoCmd.GoToRecord , , acPrevious
cmdPrior_Click:
Exit Sub
HandleIt:
If Err.Number = 2105 Then
MsgBox "You are at the first Region - for Entering Puchase Orders!"
DoCmd.GoToRecord , , acFirst
End If
Resume cmdPrior_Click
End Sub
Private Sub cmdNext_Click()
On Error GoTo HandleIt
DoCmd.GoToRecord , , acNext
cmdNext_Click:
Exit Sub
HandleIt:
If Err.Number = 2105 Then
MsgBox "You are at the last Region - for Entering Puchase Orders!"
DoCmd.GoToRecord , , acLast
End If
Resume cmdNext_Click
End Sub
Also, I think most developers steer away from using Navigation Forms because they are very limiting. It is much easier to just use normal forms and create your own "Navigation" system.