Form Data Entry Events - Tab and Enter Event

[drow]

Hello All,



I am trying to not make the database users despise me by automating some of the form data entry by controlling the sequence in which fields are entered so that it is in a logical order. I am trying to find an event that engages only if the user hits the TAB or ENTER keys to exit the current control and move to the next field they have to enter data into on the form. I have searched around on this forum for posts on this topic but it turns out that the words tab and enter are used quite frequently in other contexts.

Currently I am using the macro builder and the GoToControl functionality to try and achieve the behavior I would like to accomplish. Is there a way to use an IF statement within the On Exit event to determine if the TAB or the ENTER key have been pressed? Alternatively, is there a specific event that captures the scenario where only the TAB or ENTER keys have been pressed? I feel like this should be a simple fix, but that I have just not found the correct resource.

Thanks

[ranman256]

You can set the order of the tab/enter using the TABindex property. Start with 0, and assign up.
If you dont want the box to get selected, set TABSTOP = NO

[Missinglinq]

Hello All,

I am trying to not make the database users despise me by automating some of the form data entry by controlling the sequence in which fields are entered so that it is in a logical order.

Then why are you doing the one thing that is sure to make the users hate you??? In my experience, there is nothing more annoying to users than forcing them to enter data in a certain order!

Doing so, when there is a specific need, i.e. before entering data in ControlB then ControlA must be populated, is one thing, but simply forcing them to follow what you consider to be logical progression is very likely not to be in line with their preferences, and very likely to assure that you won't be named Co-Worker of the Month!

Linq ;0)>

[RonL]

The merits of the other responses notwithstanding, OP may wish to check out the Keydown event:

http://msdn.microsoft.com/en-us/libr...ice.15%29.aspx

-Ron

[drow]

Thank you everyone for you responses. ranman, that is exactly what I was looking for - I was unaware of that functionality.

Missinglinq, thanks for your comments. In general I agree with you which is why I didn't like the options that were available for the on exit as it forced the user to a, on key down etc events. Before the tab order was quite random, now it is some kind of logical order. Also, in the context I am using, with cascasding combo boxes, I feel that usage of the tab order is reasonable. That being said