 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Forms / May 2007Yes/No check boxes in Option Group
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 >>If yes is checked in the first box, no is automatically checked inthe others. This is how option groups work. >>I can then go back and change the selection on the other boxes individually 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.  SignatureKARL DEWEY Build a little - Test a little > 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 [quoted text clipped - 9 lines] > > Jeri 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 > >>If yes is checked in the first box, no is automatically checked inthe > others. [quoted text clipped - 18 lines] > > > > Jeri Click on form and then on menu VIEW - Code. See what may be there that would do this action. SignatureKARL DEWEY Build a little - Test a little > Karl ~ > [quoted text clipped - 35 lines] > > > > > > Jeri 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 > Click on form and then on menu VIEW - Code. See what may be there that would > do this action. [quoted text clipped - 38 lines] > > > > > > > > Jeri 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. SignatureKARL DEWEY Build a little - Test a little > Karl ~ > [quoted text clipped - 61 lines] > > > > > > > > > > Jeri 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 > 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 [quoted text clipped - 65 lines] > > > > > > > > > > > > Jeri |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2009 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.