[MS_AccessPros] Re: Need to use mutually exclusive checkboxes with data source

 

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.

If you have something like a list of colors: Red Blue Yellow you could use a table with two fields: The color and an autonumber.

1, Red

2, Blue

3, Yellow

Then add a field to your main table and set the data type as Long. Set your option group buttons to 1, 2, 3.

Do you see where I'm going with this?

Regards,

Bill Mosca, Founder - MS_Access_Professionals

http://www.thatlldoit.com

Microsoft Office Access MVP

https://mvp.microsoft.com/en-us/PublicProfile/35852?fullName=Bill%20%20Mosca

My nothing-to-do-with-Access blog

http://wrmosca.wordpress.com

---In MS_Access_Professionals@yahoogroups.com, <desertscroller@cox.net> wrote :

There is radio buttons but a data source does not appear to be used for labeling.

---In MS_Access_Professionals@yahoogroups.com, <liz_ravenwood@...> wrote :

I haven't done it, but does Access have radio buttons?

 

From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Friday, June 17, 2016 11:50 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Need to use mutually exclusive checkboxes with data source

 

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

Rod

 

__._,_.___

---

Posted by: wrmosca@comcast.net

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (5)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• New Members 2

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___