>i have a grid with about a 100 rows, i want to use the ENTER key to enable the user to move to the start of a new row when he reaches the last column.
>at present it come to the start of the same row. the row does not change.
In the LostFocus event of the control that is the CurrentControl of the last column in the grid, put the following.
If LastKey() = 13 && Enter
With this.Parent.Parent
.Column1.SetFocus()
Skip In (.RecordSource)
EndWith
EndIf
The first column's name should be used instead of
Column1
, unless, of course, the first column's name is
Column1
:)
Insanity: Doing the same thing over and over and expecting different results.