Check List with check boxes

[Chespirito]

Hello, I need some advise on how to build this form. I created the first page but it seems like I have to create way too many check-boxes. The access report must look like the "HQS Form" attached. I created a check box for each Yes, No, Inconclusive field but if you look at the HQS form I have to create about 80 check boxes. Do I have to create a field for each box or is there a better way of doing this ? any help will be much appreciated. I have a table that pulls the name and address from another table and the rest check boxes are on a another table for now until I figure out how to structure it. See MS access form to see what I have so far.

 

[Chespirito]

Thank you for your quick response Gizmo, I saw checked out your videos and the seem a bit overwhelming for me since I am not a programmer. Can your sample be customized to fit my needs without much coding. you can email me here if you prefer. platanudo@hotmail.com thank you.

 

[Chespirito]

Great! thank you so much for the free download and thank you for your patience. I will try to apply that to what I am doing. I will let you know how it turns out. Thanks a million again.

 

[Chespirito]

Pat, I did the option groups for "Type of inspection, Housing type and Summary Decision" but I am stuck on how to do the following items (1. Living Room Present) etc. I attempted to use an option group but I only end up with one option per column and I need 3 options per row (Yes Pass / No Fail / Inconclusive). and what about the comments and dates ? will these have to be single fields ?

Uncle Gizmo is a "genius" what he created is great. I could not figure out how to implement it on my database. I attempted to revere engineer but failed. hahaha I am stuck. I thank you for your time and suggestions.