Sub Form displayed as Datasheet.

[Guest]

I have a Form with two sub forms. The first sub form is displayed as a
Datasheet. The datasheet consists of a set of columns. I have it set so that
the user can quickly tab across to the next column. By default when the user
hits tab while the last column is in focus the cursor is droped down to a
brand new row. I am seeking to stop the cursor from dropping down to the next
row, and instead take focus of a control within the second sub form. Any
ideas of how to accomplish this would be greatly appreciated.

William

 

[Rob Oldfield]

There are limitations on the code you can attach to datasheet forms and I
think you just ran into one. You'd be better off just designing the form so
that it *looks* like a datasheet. If you do it that way then you can just
catch the KeyDown event of the last column, check whether the KeyCode is 9
(for a tab) and take whatever action you want.