Moving Cursos - newbie question

[Guest]

I have a form where I enter numerical data into 4 columns. Typically, there
are about 30 rows. Because of the nature of the values, it is easier to
enter the data for each column from top to bottom before going to the next
column. I currently enter a value then have to tab 4 times before I enter
the next value below the previous one.

What's an easy way to do this? How can I make the down arrow move the
cursor 'down' one row?

Thanks
Victoria

 

[Guest]

In your form, put the following code in the Keydown event of your form

Private Sub Form_KeyDown(KeyCode As Integer, Shift As Integer)
Select Case KeyCode
Case vbKeyDown
DoCmd.GoToRecord
End Select
End Sub

Please let me know if I can provide more assistance.