I have nine checkboxes in my form
named like this
check1
check2
check3
check4
...
check9
i want to create a loop that loops them and if they are checked then do something
i wrote something like this
-
-
dim name as string
-
dim iter as integer
-
iter = 1
-
-
-
-
Do
-
-
name = "check" & iter
-
-
if me.name.value = -1 then
-
-
do something
-
-
end if
-
-
iter = iter + 1
-
-
loop until iter = 10
-
but i keep getting errors
i also tried something like this
-
-
if check & iter.value = -1 then
-
-
do something
-
end if
-
-
also error
how can i do the above loop??
