Checkbox like hotmail or any other web-based email

[BK]

Dear all,

I need help with access 2000. I have a form "Child" with subform
"Grand" (3 levels). I have a toggle box in every record in the lowest
level of the form for status. I want to have a toggle box in the
parent form (2nd level) that when I update it, all the toggle boxes in
the subform are updated, but I still have the ability to update the
toggle box manually and individually.

If I set the recordsource to equal to the field in the mainform, I
can't make changes to individual checkboxes because it is locked. I
want it to be like hotmail, where you tick the checkbox on top, every
checkbox is ticked, but you still have the ability to untick checkbox
individually.

Please help. Any advise will be greatly appreciated.

BK

[PC Datasheet]

Make the toggle box in the parent form unbound. Then in the AfterUpdate event
of the togglebox run an update query to set the toggleboxes in the subform to
true if they are unchecked and false if they are checked. The pseudocode is:

If Me!ParentTogglebox = True Then
Execute update query Me!Subform!togglebox = True
Else
Execute update query Me!Subform!togglebox = False
End If
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
re******@pcdatasheet.com
www.pcdatasheet.com
"BK" <ka*****@hotmail.com> wrote in message
news:f4**************************@posting.google.c om...

Dear all,

I need help with access 2000. I have a form "Child" with subform
"Grand" (3 levels). I have a toggle box in every record in the lowest
level of the form for status. I want to have a toggle box in the
parent form (2nd level) that when I update it, all the toggle boxes in
the subform are updated, but I still have the ability to update the
toggle box manually and individually.

If I set the recordsource to equal to the field in the mainform, I
can't make changes to individual checkboxes because it is locked. I
want it to be like hotmail, where you tick the checkbox on top, every
checkbox is ticked, but you still have the ability to untick checkbox
individually.

Please help. Any advise will be greatly appreciated.

BK