disable check box based on other checkbox

[deb]

Access 365
Within my main form f_pac,
I have 3 check boxes (USA, Canada, Combined)

I need to have them enabled/disabled.

If either USA or Canada is checked then disable Combined.
and
if Combined is checked disable USA and Canada.

How can I do this?

 

[xenou]

you untick and that enables again.

Okay. Yes, you could have everything enabled if anything is unticked (open all choices again).

 

[Micron]

Absolutely agree that option buttons would be more elegant. However, if they must be check boxes for some reason (perhaps they are bound which would suggest that there are 3 table fields instead of one) then this should work:

Private Sub chkCanada_Click()
  If Me.chkUSA = -1 Then Me.chkUSA = 0
  Me.chkCombined.Enabled = Not Me.chkCanada
End Sub

Private Sub chkUSA_Click()
  If Me.chkCanada = -1 Then Me.chkCanada = 0
  Me.chkCombined.Enabled = Not Me.chkUSA
End Sub

Private Sub chkCombined_Click()
  Me.chkCanada.Enabled = Not Me.chkCombined
  Me.chkUSA.Enabled = Not Me.chkCombined
End Sub

Maybe OP is absent because he/she got the answer from some other forum...