Yes/No check boxes in Option Group

[Guest]

I have a questionnaire form that is mostly questions with yes/no responses.
I have created several option groups with yes/no checkboxes. When the first
checkbox is clicked all of the others get checked as well. If yes is checked
in the first box, no is automatically checked inthe others.

I can then go back and change the selection on the other boxes individually,
but really don't want users to have to do this.

Any ideas?

Thanks much,

Jeri

 

[Guest]

If yes is checked in the first box, no is automatically checked inthe
others.
This is how option groups work.
This is not how an option group works. You must have something else.
An option group is a bunch of display items that have ONLY one field bound
and records a number to indicate which of the group was selected.

 

[Guest]

Karl ~

I think maybe I didn't explain my situation correctly. One option group has
a check box for yes and a checkbox for no. I have several different option
groups on the same form. If I check yes in one option group, no is
automatically checked in all of the others (these are all seperate option
groups, not different checkboxes in the same group). I would they they would
work independently of one another.

Each option group is attached to a yes/no field in the underlying table.

Hope that makes it a little more clear.

Thanks,

Jeri

 

[Guest]

Click on form and then on menu VIEW - Code. See what may be there that would
do this action.

 

[Guest]

Karl ~

There doesn't seem to be any innocuous code. Here is an example of what is
there:

Check171 is the Yes checkbox in one of the option groups and Check173 is the
No checkbox in the same option group. Each of the checkboxes in each of the
option groups have basically the same code.

Private Sub Check171_GotFocus()

End Sub

Private Sub Check173_GotFocus()

End Sub

Still baffeled!

Thanks,

Jeri

 

[Guest]

Sometimes the only way is to wipe it out and do it again.
Save form with a different name - add a -X. Open the orignal in design view
again and delete the option group and re-create it again.

 

[Guest]

Karl ~

Thanks for all your help. Frankly, I gave up and created the form in
InfoPath, connected it to the database and it works like a charm!

Thanks again,

Jeri