Solved

MS Access 2007, Choose one check box

Posted on 2013-05-28
5
400 Views
Last Modified: 2013-05-28
Hi All,

I have an Access 2007 database.  There are a group of check boxes where the user will choose one box for ethnicity.  Is there a way where the user will only be allowed to check one box? So if the user checks a box and changes their selection when they click on the new box the old box will be unchecked.

Please see attachment.

Thanks in advance.
Database2.accdb
0
Comment
Question by:Reyesrj
  • 3
  • 2
5 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
ID: 39203359
place the check boxes inside an Option Group.
0
 

Author Comment

by:Reyesrj
ID: 39203388
Thanks but I'm not sure how to do that.
0
 
LVL 119

Accepted Solution

by:
Rey Obrero earned 500 total points
ID: 39203440
changed the design of your table Ethicity
Database2Rev.accdb
0
 

Author Comment

by:Reyesrj
ID: 39203519
Okay, I figured it out.  Will I be able to use that data?  If so, how or where would it be.  I query tables into excel.
0
 

Author Closing Comment

by:Reyesrj
ID: 39203629
Sorry, I just looked at the main table.  Thank you very much.  This helps a lot!!!
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of utilizing SQL Server views from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Access…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

932 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now