header checkbox to check or uncheck multiple boxes in access
Posted on 2014-01-03
I would like to know how i can make a multiple selection check box to select or deselect the header check box all the below check boxes are checked or unchecked.
In access 2007 I have one subform connected with fields have check box Yes/No for taking attendance. When the form opens, all boxes are checked. If a student is absent i will uncheck, it is big job if i have hundreds of students to track their attendance. i want to create a check box on the header of the form for each row and column to select or deselect all the check boxes in the column or row and uncheck or check.
I would greatly appreciate if someone please help me on this