Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

MS Access 2007, Choose one check box

Posted on 2013-05-28
5
Medium Priority
?
447 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 2000 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

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Question has a verified solution.

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

Traditionally, the method to display pictures in Access forms and reports is to first download them from URLs to a folder, record the path in a table and then let the form or report pull the pictures from that folder. But why not let Windows retr…
Code that checks the QuickBooks schema table for non-updateable fields and then disables those controls on a form so users don't try to update them.
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 …
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

564 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