Down arrow

  • Thread starter Thread starter Bill
  • Start date Start date
B

Bill

When I click the down arrow on my Tabular form I want it
to go to the next record. Is this easy?
Tnks
Bill
 
I assume a continues form.

I also like it when down-arrow moves to the next record. It means the
continues form behave like excel..or even the datasheet view in ms-access.

What I do si set the forms key-preview = yes...and then use the follwing
code in the keydown eventfor the form

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

' key hand

Select Case KeyCode

Case vbKeyUp
KeyCode = 0
On Error Resume Next
DoCmd.GoToRecord acActiveDataObject, , acPrevious

Case vbKeyDown
KeyCode = 0
On Error Resume Next
DoCmd.GoToRecord acActiveDataObject, , acNext

End Select

End Sub
:
 
Back
Top