Using Case statements (1 Viewer)

[comicwizard]

hi, I need help making a case statement.
I have a form with 9 check boxes. The intent is you are able to choose 1 through eight choices. if you do the 9th check box deactivates. If you unchoose all of them then the 9th box becomes active. If you only choose the 9th box the first 8 becomes deactive.

I can write if then statements for each check box but I thought using a case statement would be less work.

I have attempted to write the case statement but it's not working. Please any help with the code would be great.

 

[pbaldy]

I don't think it's that complicated:

If Nz(Me.Check1,0) + Nz(Me.Check2,0) + ... + Nz(Me.Check8,0) = 0 Then
  'none were selected.