[AccessD] Form Controls

Well, the tab order only works for the section that the focus is in anyway, so have three 
collections, one for each section.

John W. Colby
www.ColbyConsulting.com


Kenneth Ismert wrote:
> Hey, all:
> 
> Charlotte Foust:
>> If you're talking about in design view, the controls follow the
>> order in which they were added, not the tab index, which
>> can be changed.
> 
> That is right initially, but the rendering order determines the Controls
> collection order. Using the Bring to Front and Send to Back buttons in form
> design view changes the control order. This is how Access handles control
> overlap without a z-index property: controls later in the collection render
> on top of those before. I'm pretty sure of this.
> 
> Tab indexes, on the other hand, get re-used by section and tab page. This
> means that if your form has header, footer  and detail sections, as well as
> a tab control with three pages, you could have 6 controls with a tab index
> of 1: one for each section and tab page.
> 
> This means that any looping through controls by tab index has to be
> recursive. You must go by section, then any tab pages in that section.
> 
> Of course, this complicates adding controls to a collection keyed by tab
> index. The straightforward way will work only for the simplest case: only a
> detail section with no tab pages. Otherwise, you will get duplicate tab
> indexes, and your item add won't work the way you expect.
> 
> -Ken