Unanswered: Assessing if User ends field with up/down key
Numeric input field in table. User enters (say) 123.45 then the down arrow key. I would like to go to the next record in the table rather than across to the next field. Can't seem to figure out how. Ditto on up arrow key. Can anyone help?
Private Sub Text1_KeyUp(KeyCode As Integer, Shift As Integer)
On Error Resume Next
If KeyCode = 40 Then
DoCmd.GoToRecord , , acNext
If Err Then
DoCmd.GoToRecord , , acNewRec