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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 494
  • Last Modified:

MS Access 2007 check box in form

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
Reyesrj
Asked:
Reyesrj
1 Solution
 
FlysterCommented:
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
 
ReyesrjAuthor Commented:
Thanks, it works!
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now