Right and Left Arrow Keys

[User via AccessMonster.com]

I have a form with two command buttons:

cmdNextRecord
cmdPreviousRecord

Is there coding out there that will allow the user to control the command
button "cmdNextRecord" On Click Event with the keyboard's right arrow key?...
And the command button "cmdPreviousRecord" with the left arrow key?

Any help would be great!!!!

 

[Daryl S]

Not sure how to code for the right/left arrow keys, but you users can use the
PageUp and PageDown keys to scroll among the records.

 

[Linq Adams via AccessMonster.com]

For the form, goto Properties - Events and set Key Preview to Yes.

Then use this code:

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyRight Then Call cmdNextRecord_Click
If KeyCode = vbKeyLeft Then Call cmdPreviousRecord_Click
End Sub

But I have to warn you, most users are going to expect the Left/Right arrows
to move the cursor to the left or right and might not like to find out that
standard functions have been removed!

 

[User via AccessMonster.com]

Events and set Key Preview to Yes.

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
If KeyCode = vbKeyRight Then Call cmdNextRecord_Click
If KeyCode = vbKeyLeft Then Call cmdPreviousRecord_Click
End Sub

Works Great!!!

Thank You!!!!!

 

[Linq Adams via AccessMonster.com]

Glad we could help!