Rod - Access has separate radio buttons as well as option groups. Option groups allow multiple radio buttons for one ControlSource. Each button will need a unique integer. You have to "translate" that integer for a value if you are using a field other than a Yes/No. If you have a Yes/No set one control to -1 and one to 0.
Then add a field to your main table and set the data type as Long. Set your option group buttons to 1, 2, 3.
---In MS_Access_Professionals@yahoogroups.com, <email@example.com> wrote :
---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@...> wrote :
I haven't done it, but does Access have radio buttons?
I am trying to make a set of checkboxes that have data source. The problem is allowing only one checkbox to be selected. The use of option group did not seem to be a good approach since the labels can not be associated with a query.
This application is a survey that uses random questions and most of the answers will be single responses. For the multiple responses the checkbox work great.
Is there another approach to mutually exclusive responses using a data source?
Windows 8.1 & 10 using Access 2010 and 2013
Posted by: firstname.lastname@example.org
|Reply via web post||•||Reply to sender||•||Reply to group||•||Start a New Topic||•||Messages in this topic (5)|