I'm having trouble finding HELP section on Tab controls

[MLH]

I can't seem to find an A97 HELP blurb telling me how to
make a specific Tab Page active from within VBA. I have
a form with 3 tabs. They work great. I want to optionally
make the first, second or third page active with a VBA
command - displaying the controls, of course, on the
desired page.

[PC D]

Pages in a tabcontrol are sequentially numbered starting with 0. To go to
the second tab, use the expression:
Me!NameOfTabcontrol.Value = 1
third tab:
Me!NameOfTabcontrol.Value = 2
etc.

--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
Over 1175 users have come to me from the newsgroups requesting help
re******@pcdatasheet.com
"MLH" <CR**@NorthState.net> wrote in message
news:3r********************************@4ax.com...

I can't seem to find an A97 HELP blurb telling me how to
make a specific Tab Page active from within VBA. I have
a form with 3 tabs. They work great. I want to optionally
make the first, second or third page active with a VBA
command - displaying the controls, of course, on the
desired page.

[Jeff Smith]

"MLH" <CR**@NorthState.net> wrote in message
news:3r********************************@4ax.com...

I can't seem to find an A97 HELP blurb telling me how to
make a specific Tab Page active from within VBA. I have
a form with 3 tabs. They work great. I want to optionally
make the first, second or third page active with a VBA
command - displaying the controls, of course, on the
desired page.

If you're opening up the form with that has the tab control form another
form the syntax is
Forms!NameOfForm!NameOfPage.SetFocus

By default every page created on a tab control is "page1", "page2" etc. Make
sure you name the page correctly first.

Jeff