Run time Error '2046'

[Pookiemeister]

I'm still new to Access, so I don't fully understand it. So I am taking an online class on Access and in the instructor's video, he has the following code:

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
   'MsgBox ("The keycode is " & KeyCode)
   'Displays the keycode for the key pressed in a messagebox
   Select Case KeyCode
      Case vbKeyEnd
         'Turns off the keys
         KeyCode = 0
         'Moves cursor to last line of the record
         DoCmd.RunCommand acCmdRecordsGoToLast
      Case vbKeyHome
         'Turns off the keys
         KeyCode = 0
         'Moves cursor to first line of the record
         DoCmd.RunCommand acCmdRecordsGoToFirst
      Case vbKeyUp
         'Turns off the keys
         KeyCode = 0
         'Moves cursor to previous line of the record
         DoCmd.RunCommand acCmdRecordsGoToPrevious
      Case vbKeyDown
         'Turns off the keys
         KeyCode = 0
         'Moves cursor to next line of the record
         DoCmd.RunCommand acCmdRecordsGoToNext
   End Select

However, when I run this code, I get the following error:
Run-time error '': The command or action 'RecordsGoToNext' isn't available now.
What does that me as far as Access is concerned. I'm not sure if the version of access matters with this code. Any help would be greatly appreciated.

 

[silentwolf]

Hi,
I have never used a Form_KeyDown Event so I am not to sure about this issue...
Do you have any records in that form?

I guess you don't have a record to GoToNext...and that is why you are getting this error well at least thats what I think it might is the problem.

HTH

 

[Micron]

I have to wonder if you were given that and expected to raise this issue and solve it yourself? If not, it's a surprising oversight - that you cannot go to next if at the end, nor go to previous if at the beginning. You have 2 choices for "fixing" - trap the error or test the cursor position (i.e. where are you in the recordset?) and either do nothing or message "You are already at the end/beginning of the records". Or just don't try to navigate beyond the first or last. In other words, don't try to advance when you're at the end and vice versa.