Moving Cursos - newbie question

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Victoria - 03 May 2007 02:17 GMT

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

Reply to this Message

hmadyson - 03 May 2007 02:39 GMT

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.

> 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
[quoted text clipped - 7 lines]
> Thanks
> Victoria

Reply to this Message