By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,327 Members | 1,789 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,327 IT Pros & Developers. It's quick & easy.

Checkbox like hotmail or any other web-based email

P: n/a
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
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
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

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.