Solved

MS Access 2007, Choose one check box

Posted on 2013-05-28
5
429 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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

Salesforce Has Never Been Easier

Improve and reinforce salesforce training & adoption using WalkMe's digital adoption platform. Start saving on costly employee training by creating fast intuitive Walk-Thrus for Salesforce. Claim your Free Account Now

Question has a verified solution.

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

Suggested Solutions

It’s been over a month into 2017, and there is already a sophisticated Gmail phishing email making it rounds. New techniques and tactics, have given hackers a way to authentically impersonate your contacts.How it Works The attack works by targeti…
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
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 …
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

734 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