Run Time Error 2105 You can't go to specific record

[psamu]

I have below code in the form properies event, I am getting run time error 2105 when I go to last record on both side (Above or below) How can I get rid of this error? Is there any way I can put this code entire form instead of each field properties? Thanks.


Private Sub Remarks_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode

Case 40
DoCmd.GoToRecord , , acNext
Case 38
DoCmd.GoToRecord , , acPrevious
End Select
End Sub

 

[xenou]

This would stop the error (and stop the record from moving any further if it reaches the first or last record) - the obvious point is that you can't move "past" the last record etc. With a few tweaks you could create a "circling" effect where the last records circles back to the first:

Private Sub Remarks_KeyDown(KeyCode As Integer, Shift As Integer)

[COLOR="Blue"]On Error Resume Next[/COLOR]
Select Case KeyCode
    Case 40
        DoCmd.GoToRecord , , acNext
    Case 38
        DoCmd.GoToRecord , , acPrevious
End Select

End Sub

I'm not sure about trapping key events on a form level, though. Perhaps you should say more about what you want to happen and how this is supposed to work - where this code is being used, and so on and so forth.

 

[psamu]

Thanks for the help.