Binding a key to a form control

[flect]

Hey everyone!

Hopefully this a simple problem

I have a working form with a few subforms that I navigate through.

I have my stock record on the main form and quantity details on the subform

Basically I want to hard code the + / - keys on the Numpad to go forward/back a record regardless what subform I'm on.

at the moment i've tried a Select Case Keycode setup but the problem is that it's locked to my main form. when i go to subform or the splitview table the buttons don't work.

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

Select Case KeyCode
  Case vbKeySubtract
  DoCmd.RunCommand acCmdRecordsGoToPrevious
  Case vbKeyAdd
  DoCmd.RunCommand acCmdRecordsGoToNext
  End Select
End Sub

I realise it's a Form_KeyDown - but i assumed that would filter through to the subforms, but that doesn't appear to be the case.

Any ideas?

 

[boblarson]

Check this out by Armen Stein, Access MVP (J Street Tech):
http://www.jstreettech.com/files/cooltool.zip

 

[flect]

Thanks Bob!

I've had a look at the VB behind the DB, but the DB itself doesn't work, it says "the project contains a missing or broken reference to the file 'utility.mda'" - no biggie, the VB should give me plenty of ideas