How do I use tickbox to update other field values ?

[alunkane]

I'm sure there is a simple answer for this, but it has me baffled...

I have designed a form with a number of (yes/no) tick-boxes. I want it so that when one particular tick box is either checked or cleared, other boxes on the form are automatically checked or cleared.

Any help would be greatly appreciated.

 

[Meltdown]

...see attachment

 

[alunkane]

Thanks

Meltdown: Many thanks

I had a look at the code for this and will have a go at adapting it...
(I'm pretty new at this carry on)

Just to be sure where to start ?

Do I just go to properties / On click / Event Procedure and type in the code starting with "Private Sub...." ?

Private Sub Check0_Click()
If Me!Check0 = True Then
Me!Check2 = True
Me!Check4 = True
Me!Check6 = True
Else
Me!Check2 = False
Me!Check4 = False
Me!Check6 = False
End If
End Sub]

 

[Meltdown]

Do I just go to properties / On click / Event Procedure and type in the code starting with "Private Sub...." ?

Private Sub Check0_Click()
If Me!Check0 = True Then
Me!Check2 = True
Me!Check4 = True
Me!Check6 = True
Else
Me!Check2 = False
Me!Check4 = False
Me!Check6 = False
End If
End Sub]

Yes you do, but make sure to change the names of the checkboxes in your code to whatever name you've given them. Post your DB if you get stuck.