One Check box to check all check boxes

[Guest]

Hi,
I have a continuous form that is using a table as a control source. Each
record has a checkbox, I put an unbound check box in the form header- when I
check this box off I want all the check boxes on the form detail to be
checked off as well and when I uncheck the check box on the form header I
want all the check boxes on the form detail to uncheck. I currently have
code for the check box in the form header that says If Me.ckboxAll = "-1"
Then Me.ckbox = "-1" Else Me.ckbox = "0" But when I check the box off on the
form header only the first check box on the form detail checks.

Thanks,
Mark

 

[Mark M]

Even though continuous forms show lots of records, only one record is the
current record and thus your code only updates the one current record. You
can create a saved update query to update the whole recordset when you click
your checkbox and then refresh/requery the data behind your form.

 

[Guest]

Thanks- that worked perfectly.

Even though continuous forms show lots of records, only one record is the
current record and thus your code only updates the one current record. You
can create a saved update query to update the whole recordset when you click
your checkbox and then refresh/requery the data behind your form.