well, it's easy enough, but you need a background understanding of the tab
control and option group first, so bear with me a minute and i'll try to
explain them so it makes sense:

the *pages* in a tab control have no Value property, but they do have a
PageIndex property which reflects the "order" of the pages within the tab
control. the index is zero-based, so the first page has a PageIndex of zero
(0), the second page's PageIndex is 1, the third page is 2, etc.

clear so far? okay, now, the tab control *does* have a Value property. the
value of a tab control is equal to the PageIndex of the currently active tab
control page. for instance, if page 3 of the tab control is "showing", then
the value of the tab control is 2 (remember that zero-based index, explained
above).

to move from one page to another in the tab control, programmatically, you
set the value of the tab control = to the PageIndex of the page you want to
move to. for instance, to move to the third page in the tab control, use the
following code, as

Me.TabCtrlName = 2

alright then, let's look at how an option group works. here again, an option
group control has a Value property. the option buttons (or checkboxes, or
toggle buttons) within the group do *not* have a Value property, but they
*do* have an OptionValue property (the difference here is that you can set
the OptionValue property of each option button to whatever you want). the
value of the option group control is equal to the OptionValue property of
the option button that the user selects. for instance, if the second option
button has an OptionValue property of 250 (remember, you can set the
property of each button to whatever you want), and that button is selected,
then the Value of the option group control = 250.

okay, let's bring it all together so that you can use an option group to
navigate between tab control pages. the scenario: create a tab control
named TabCtrl0, with three pages (the PageIndex property of the respective
pages are 0, 1, and 2). create an option group named grpChoice, with three
toggle buttons. when you click the first button, you want to see the first
tab control page, so set the OptionValue property of the button to zero (0);
you want the second button to take you to the second page, so set the second
button's OptionValue property to 1; and of course the third button's
property will be set to 2, to move to the third tab control page.

after setting up the controls and their properties as described above, add
the following code to the *Click event procedure of grpChoice*, as

Me!TabCtrl0 = Me!grpChoice

yes, it really is that simple, once you understand how the tab and option
group controls work, and how to use them together.

hth


"cprav" wrote in message
...
Hi tina,

I like this suggestion, but I'm wondering what I do to the toggle buttons
to
make them go to each page - how do I set them up? I'm just learning
access,
but always seem to want to do more difficult things!

Thanks!

"tina" wrote:

personally, i love the TabControl and use it a LOT in my databases'
forms,
but i hate the way it looks. so i set the control's BackStyle property
to
Transparent, and the Style property to None (no tabs or buttons). so my
users don't "see" the tab control at all, only the objects i place on
each
page of the control. in order to navigate between pages, i use an option
group with toggle buttons - one button for each page.

hth


"sandrao" wrote in message
...
Is there any way to change the background color on a Tab Control form.
The
default color is some sort of gray color. I would like to the Tab
control
form along with its tabs blend in with the Design view form that it
in
embetted in.
There seems to be nothing in its properities that allows for color
change.