Looping syntax

[fadiaccess]

Hi Guys,


I am new in VBA. I need your help cause I am not able to get it.
What I am trying to accomplish is the following:
I have 3 sets of check boxes. (Total of 9)

Set one:
Checkbox1 name is catname
Checkbox2 name is cat1
Checkbox3 name is cat2

Set two:
Checkbox1 name is dogname
Checkbox2 name is dog1
Checkbox3 name is dog2

Set three:
Checkbox1 name is birdname
Checkbox2 name is bird1
Checkbox3 name is bird2

I want to write a code, where if any of the checkbox that ends with "name" are checked, then checkbox that ends with "1" is disabled.
I am trying to do that in a loop.

Can you please help.

Thanks.

[SoftwareMatters]

I would do this on the Oncurrent of the form and AfterUpdate of the "name" checkboxes. It would be something like this:


If Me!CatName = Yes then
Me!Cat1.Enabled = False
Else
Me!Cat1.Enabled = True
End If

You get the idea.