Solved

MS Access 2007, Choose one check box

Posted on 2013-05-28
5
420 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 120

Expert Comment

by:Rey Obrero (Capricorn1)
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 120

Accepted Solution

by:
Rey Obrero (Capricorn1) 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

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

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

I originally created this report in Crystal Reports 2008 where there is an option to underlay sections. I initially came across the problem in Access Reports where I was unable to run my border lines down through the entire page as I was using the P…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

820 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