Tab Order

[Guest]

I have a form with 3 tabs in it. I want to set the tab order so it goes thru
all the fields in the main form first then to all the fields each tab.

 

[Perry]

You almost got it indeed

First taborder the mainform
(note: TabControl to be tabordered after last mainform control)
Select TabControl and set the taborder there.
If there are any subforms on yr TabControl, ... etc.

Krgrds,
Perry

 

[Guest]

Thanks Perry for responding to me. I do have TabControl as the last
tabordered in the mainform but it only goes thru the first tab and skips over
the other 2 tabs and then starts back to the first field in the mainform
again.

Is there a way to taborder the entire tab or page so it goes thru everything?

 

[Guest]

Perry, I think what I'm trying to say is that I can't get to the taborder in
the TabControl.

 

[Perry]

Select a tab and in the properties pane look at property
Page Index

0 for first tabstop
1 for second tabstop
....etc

Krgrds,
Perry

 

[Guest]

that's what I have; page index for the first tab is 0, second tab is 1, and
third tab is 2. It only goes thru all the fields on the first tab and skips
over the second and third tab.

Thanks!

 

[Perry]

)
Aha, ok
You'll need a bit of VBA to enforce this.
Enter below lines in the Exit_ event of the last control
on first tab (value 0) of yr tabcontrol.

Me.Mytabcontrol.Value = 1
Me.Mytabcontrol.pages(1).controls(0).setfocus

Krgrds,
Perry

 

[Guest]

Perry, I kinda new at this so you'll have to walk me thru - I copied and
pasted what you have where you told me to put it but I got an error about a
macro... Am I supposed to replace "Me" or "Mytabcontrol" with my form name?
or should I create a macro?

Thank you for being real patient with me.

 

[Perry]

ok,
sorry for that

What's the name of the control last in the taborder sequence on first page?
What is the name of the tabcontrol?

Pls advise

Krgrds,
Perry

 

[Guest]

Good Morning Perry,

The name of the last control is "Other Competitor" and the name of the
tabcontrol is called "tbDealInfo"

Thanks for your help!