Two sets of tab orders??

[GD]

I have a form that has 2 sections, each of which needs their own exclusive
tab order. When the user tabs at the bottom of either section, the next
record needs to open and the tab needs to go to the top of that particular
section. Can I...

A) put the 2nd section in a subform, but bind it to a different table than
the main form? (NOTE: If I go this route, two separate tables would be
required.)

or B) somehow custom tab stop one section while in the other? Would a check
box be of any use (i.e. when one check box is checked, the tab order stays in
that section, and vice versa)?

Thanks for your time!

 

[John W. Vinson]

I have a form that has 2 sections, each of which needs their own exclusive
tab order. When the user tabs at the bottom of either section, the next
record needs to open and the tab needs to go to the top of that particular
section. Can I...

A) put the 2nd section in a subform, but bind it to a different table than
the main form? (NOTE: If I go this route, two separate tables would be
required.)

or B) somehow custom tab stop one section while in the other? Would a check
box be of any use (i.e. when one check box is checked, the tab order stays in
that section, and vice versa)?

This sounds like an opportunity to change an occasional annoyance into a
benefit: if you use a Tab Control on your form, each tab page has its own
independent tab order for controls on that page.