you're very welcome, and thank *you*, too.


"cprav" wrote in message
...
Tina,

Thank you so much! Of course, it worked! I had no doubts about that,
although I was starting to wonder when it just wouldn't work - until I
realized I'd made a typo!

I appreciate your quick response - and also the thoroughness(??) of it. I
really appreciated the background info you supplied instead of just giving
me
the code at the end. It helped me understand it and perhaps use the
information in different ways in the future. I spent a lot of time in
these
forums and this is the best reponse on any topic I have received.

Thanks again!

Cprav.

"tina" wrote:

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.