One Check box to check all check boxes

One Check box to check all check boxes

Post by TWFyayBTZW » Wed, 13 Apr 2005 22:01:05


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

--
MSS
 
 
 

One Check box to check all check boxes

Post by Mark » Wed, 13 Apr 2005 23:36:59

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.

 
 
 

One Check box to check all check boxes

Post by TWFyayBTZW » Thu, 14 Apr 2005 00:27:02

Thanks- that worked perfectly.