Disabling selected checkboxes when one other checkbox is selected

[Tafi]

Please help. I have, say, 10 checkboxes on a form. I would like the form to disable, say checkbox 7 and 8 if I select checkbox 1. How do I achieve this.

[MMcCarthy]

Please help. I have, say, 10 checkboxes on a form. I would like the form to disable, say checkbox 7 and 8 if I select checkbox 1. How do I achieve this.

In the After Update event of checkbox 1 you can put the following code. I am using 'check1' as the checkbox name you will need to change it.

Private Sub check1_AfterUpdate()
 
   If check1 Then ' if checkbox 1 is ticked
      Me.check7.Enabled = False
      Me.check8.Enabled = False
   Else
      Me.check7.Enabled = True
      Me.check8.Enabled = True
   End If
 
End Sub
 

Mary

[Tafi]

Thanks lots Mary. It works great.

[MMcCarthy]

Thanks lots Mary. It works great.

That's good Tafi

I'm glad to hear it.

Mary

[NeoPa]

Another way of doing it :

Private Sub Check1_AfterUpdate()
    Me!Check7.Enabled = Not Me!Check1
    Me!Check8.Enabled = Not Me!Check1
End Sub

[MMcCarthy]

Another way of doing it :

Private Sub Check1_AfterUpdate()
    Me!Check7.Enabled = Not Me!Check1
    Me!Check8.Enabled = Not Me!Check1
End Sub

Did you do this while you were talking to me Ade or since.

Anyway, I remembered this after I posted but am so used to doing it the other way I didn't think of this at the time.

Mary

[NeoPa]

I think this was before in fact.