Hi,

Sorry for such a newbie question and probably one already asked. I have a
form that I made and in some cells, I have check boxes for yes and no. I
know how to link the check boxe to other cells that will later be used as
field data to be imported to access.

What I need to know is how to set a formula, so when you check yes, you
won't be able to check the no box and vice versa. Is this possible? Thank
you.

Why not use optionbuttons, that is a property of optionbuttons implicitly.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Hell-fire" wrote in message
...
Hi,

Sorry for such a newbie question and probably one already asked. I have a
form that I made and in some cells, I have check boxes for yes and no. I
know how to link the check boxe to other cells that will later be used as
field data to be imported to access.

What I need to know is how to set a formula, so when you check yes, you
won't be able to check the no box and vice versa. Is this possible?
Thank you.

Thank you Bob,

I would like to use option buttons, but I have 15 different sections to use
the yes/no and other select type fields. When I try to link each set of
option buttons to a particular cell, all the option buttons link to the same
one. Is there a way to have each options button set link to different cells.

"Bob Phillips" wrote:

Why not use optionbuttons, that is a property of optionbuttons implicitly.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Hell-fire" wrote in message
...
Hi,

Sorry for such a newbie question and probably one already asked. I have a
form that I made and in some cells, I have check boxes for yes and no. I
know how to link the check boxe to other cells that will later be used as
field data to be imported to access.

What I need to know is how to set a formula, so when you check yes, you
won't be able to check the no box and vice versa. Is this possible?
Thank you.

You can also group option buttons.

If they are from the forms toolbar you can group them within a frame.

If they are from the control toolbox, they have a Group property which you
can set.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Hell-fire" wrote in message
...
Thank you Bob,

I would like to use option buttons, but I have 15 different sections to
use
the yes/no and other select type fields. When I try to link each set of
option buttons to a particular cell, all the option buttons link to the
same
one. Is there a way to have each options button set link to different
cells.

"Bob Phillips" wrote:

Why not use optionbuttons, that is a property of optionbuttons
implicitly.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Hell-fire" wrote in message
...
Hi,

Sorry for such a newbie question and probably one already asked. I
have a
form that I made and in some cells, I have check boxes for yes and no.
I
know how to link the check boxe to other cells that will later be used
as
field data to be imported to access.

What I need to know is how to set a formula, so when you check yes, you
won't be able to check the no box and vice versa. Is this possible?
Thank you.

Thank you Bob, that works

"Bob Phillips" wrote:

You can also group option buttons.

If they are from the forms toolbar you can group them within a frame.

If they are from the control toolbox, they have a Group property which you
can set.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Hell-fire" wrote in message
...
Thank you Bob,

I would like to use option buttons, but I have 15 different sections to
use
the yes/no and other select type fields. When I try to link each set of
option buttons to a particular cell, all the option buttons link to the
same
one. Is there a way to have each options button set link to different
cells.

"Bob Phillips" wrote:

Why not use optionbuttons, that is a property of optionbuttons
implicitly.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Hell-fire" wrote in message
...
Hi,

Sorry for such a newbie question and probably one already asked. I
have a
form that I made and in some cells, I have check boxes for yes and no.
I
know how to link the check boxe to other cells that will later be used
as
field data to be imported to access.

What I need to know is how to set a formula, so when you check yes, you
won't be able to check the no box and vice versa. Is this possible?
Thank you.