I want to connect a single check box to a record of check boxes, so that when it is on yes (checked) all the other boxes are yes (checked) automatically. How do I go about doing this? Is there an expression I can build for it?
Check box (1 Viewer)
- Thread starter cruzpatas
- Start date
ghudson
Registered User.
- Local time
- Today, 03:16
- Joined
- Jun 8, 2002
- Messages
- 6,195
You need to use an update query [SQL] to update all of the records [in the record souce]. Use the after udpate event of the 'one' checkbox to kick off your update to all of the other records. A check mark [True/Yes] = -1 in code.
Check out my sample database:
http://www.access-programmers.co.uk/forums/showthread.php?p=443575#post443575
http://www.access-programmers.co.uk/forums/showthread.php?p=443575#post443575
Hi.
I tried your ExampleDB in the forum thread above.
It only checkes one post in my form.
I have a list that varies in size. Usually its varies between 4 to 30 posts. I would like the check all of them with with one click.
Your exampleDB only checked one of the posts (the first post in the formlist).
I used your code, and called the checkboxes ck2, while the "mother box" had the name ck1. I used the code in the afterupdate section.
Do you know why this happens?
I tried your ExampleDB in the forum thread above.
It only checkes one post in my form.
I have a list that varies in size. Usually its varies between 4 to 30 posts. I would like the check all of them with with one click.
Your exampleDB only checked one of the posts (the first post in the formlist).
I used your code, and called the checkboxes ck2, while the "mother box" had the name ck1. I used the code in the afterupdate section.
Do you know why this happens?
