Solved

MS Access 2007 check box in form

Posted on 2013-05-23
2
479 Views
Last Modified: 2013-05-28
Hi All,

Please see the attached MS Access 2007 database.  In my “main” table, I chose yes/no for data type.  When I bring these fields into the form the check box is filled and will not toggle with a check mark.

Please help
Thanks
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
2 Comments
 
LVL 22

Accepted Solution

by:
Flyster earned 500 total points
ID: 39193360
The reason you can't use the checkboxes is because of the relationship you established between the two tables. You're using an autonumber in your table which isn't generated until a record is entered, so the number in your main table isn't matching the one in the Ethnicty table. I added a new field to that table and related it to the ID of the main table. On the form there's a text box that has it's default value set to the main id. See attached.

Flyster
Database2.accdb
0
 

Author Closing Comment

by:Reyesrj
ID: 39202934
Thanks, it works!
0

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
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…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.
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 …

617 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