using check boxes

[Hell-fire]

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.

 

[Bob Phillips]

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)

 

[Guest]

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]

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)

 

[Guest]

Thank you Bob, that works

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)