Use check box to indicate Pass/Fail

[Bill Phillips]

I would like to use a check box (or any other indicator whatever is best) to
indicate if an item has passed or failed a test. For each item I have 10
tests. I know with a lot of effort I can simply add a bunch of check boxes
and loop through my form to add the records to my test detail table (1
item-multiple tests). I have my tests entered in a master table and I would
like to bind the check box description to the table. Is this possible? I
really don't want to use a list box with multiple selections because I think
it is harder to view. Any suggestions??

Thanks in advance.

 

[Golfinray]

I use check boxes bound to my table. Just add the yes/no fields to your
table. It will save in your table as -1 for yes and 0 for no.

 

[Bill Phillips]

This isn't what I was looking for. I have a master table of tests. I do not
want the master table to update, I just want to use the table as a control
source for the tests. what I want then, is a list of the tests available to
me, that I can check. Then I will programmatically add them to a table I will
call TestDetail. This table will consist of an item ID and a test if it is
checked. There could be multiple entries in this table for a single item.
Basically I guess my question is how do I automatically add all my tests to
an entry form and bind a check box to them?