Tabbing from subform to subform when entering data

[oleBucky]

I have a form with 5 subforms. All 6 forms have essential data entry boxes. The tab stops work fine when jumping from the main form to the first subform. Not so when jumping from the first subform to the second subform.

When tabbing out of the last data entry text box on the first subform, how would one go about having the cursor jump to the initial tab stop on the second subform? Second to third and so forth?

[ketbdnetbp]

You might try something like this in an after update or on exit event in the last control in the subform...

Dim strSubformControlX As String
strSubformControlX = "NameofSubform"
DoCmd.GoToControl strSubformControlX
DoCmd.GoToControl "Nameoffirstcontrolonsubform"

Repeat for each subform, change name of the subform and var accordingly.

However, you may also have to address the circumstance where the user doesn't follow the normal flow of the form.

All the best !

[kennejd]

Put this on the 'on exit' event of the last control of each subform:

SendKeys "^{TAB}"

[oleBucky]

The SendKeys code works! Great! I would have NEVER come up with that code.

However, it makes the values on the subform you are tabbing from go blank. It does not erase the values in the table that serves as a record source for the form, it just makes the values in the form disappear.

I, in my brutish way, got around this by adding a Requery to the "On Enter" for the form tabbed into. Might there be a more "elegant" way to do this? Otherwise, I will consider this issue solved!

[kennejd]

I would probably use the requery method too....inelegant but effective...

I'm not sure why the values are blanking out, though....I can't duplicate that in my database.