could someone please have a look at my record nav buttons and tell me whats wrong there?
There is a bug somewhere and i can't find it, since access doesn't let me use the debugger for whatever reason.
There's also the problem that when the last record is reached and i press the next button the new record apprears and after pressing the next button again the last record appears again. how can i disable the new record so that by clicking on next one will never come to the new record, but only of i press the new record button. hope the problem is clear now ;-)
any help is greatly appreciated !! Thanks in advance !!

code:

'code for nav buttons ...
Private Sub cmdNext_Click()
On Error GoTo Err_cmdNext_Click

DoCmd.GoToRecord , , acNext
cmdPrevious.Enabled = True

Exit_cmdNext_Click:
Exit Sub

Err_cmdNext_Click:
If Err.Number = 2105 Then
Call cmdLast_Click
cmdPrevious.SetFocus
cmdNext.Enabled = False
Else
MsgBox Err.Number & " " & Err.DESCRIPTION
Resume Exit_cmdNext_Click
End If
End Sub
Private Sub cmdPrevious_Click()
On Error GoTo Err_cmdPrevious_Click

DoCmd.GoToRecord , , acPrevious
cmdNext.Enabled = True

Exit_cmdPrevious_Click:
Exit Sub

Err_cmdPrevious_Click:
If Err.Number = 2105 Then
Call cmdFirst_Click
cmdNext.SetFocus
cmdPrevious.Enabled = False
Else
MsgBox Err.Number & " " & Err.DESCRIPTION
Resume Exit_cmdPrevious_Click
End If
End Sub
Private Sub cmdFirst_Click()
On Error GoTo Err_cmdFirst_Click

DoCmd.GoToRecord , , acFirst
cmdNext.Enabled = True

Exit_cmdFirst_Click:
Exit Sub

Err_cmdFirst_Click:
MsgBox Err.Number & " " & Err.DESCRIPTION
Resume Exit_cmdFirst_Click

End Sub
Private Sub cmdLast_Click()
On Error GoTo Err_cmdLast_Click

DoCmd.GoToRecord , , acLast
cmdPrevious.Enabled = True

Exit_cmdLast_Click:
Exit Sub

Err_cmdLast_Click:
MsgBox Err.Number & " " & Err.DESCRIPTION
Resume Exit_cmdLast_Click

End Sub
Private Sub cmdNew_Click()
On Error GoTo Err_cmdNew_Click

DoCmd.GoToRecord , , acNewRec

Exit_cmdNew_Click:
Exit Sub

Err_cmdNew_Click:
MsgBox Err.Number & " " & Err.DESCRIPTION
Resume Exit_cmdNew_Click

End Sub