Creating Option Groups in Form Design

[pmlynch]

I am creating a database for a magazine that contains all of the information of our editorial board. Ideally we want to be able to search the database to narrow down which editors to use for what project. I have created option boxes with our editor's knowledgeable topics inside of them. Then once I go into the regular viewing mode I can only click on one option button as opposed to being able to click on several. Can anyone tell me how to do that?

 

[CEH]

Its a fairly simple one... using the Access wizard... Once you bring up the "tools" and click on the "Option Group" then click on your form you can start building your option group... To make it simple, an example would be an option group to pick "Male" "Female"........ As you go through the wizard you type in your options... Male...Female... then assign a value... say 1, and 2... Now in your table you would have a field called (example) "Gender" with a field type "Number".. in the option group....which I would call "optGender" ... your control source would be set to "Gender" (the field in your table) As you then go thru each record and pick Male or female it will store a value of 1 or 2 to the Gender field.(assuming the form is based on a query containing the field "Gender"
You now have a value in the field that you can create queries and filter in the criteria...... Hope that at least gets you headed in the right direction.

 

[missinglinq]

Curtis gave a very good explanation of how to use Option Groups, but missed the point of your post, in the same manner that you have missed the point of Option Groups! The whole point of an Option Group is that you can only pick one option! If you want to be able to make multiple choices, you have to use multiple checkboxes or radio buttons. You can place them within a rectangle on the form, for grouping/formatting reasons, but not within an Option Group.

Linq

 

[CEH]

I don't think I missed any point Linq..... If you read his post again it says....... "Then once I go into the regular viewing mode I can only click on one option button as opposed to being able to click on several." So for whatever reason I am assuming he DOES only want to pick one option. Yes, I see better methods too.... But he wanted option groups....so I gave him option groups

 

[missinglinq]

Maybe you're right, Curtis, but that's not the way it sounds to me! Maybe if the OP comes back we can find out! As I said, you gave a very good explanation on using Option Groups!

Linq