Collection control within a form

[crowegreg]

I have a form with many checkboxes for the user to select. Each checkbox has a label associated with it. I'm using the following code to determine which checkboxes have been selected:



For Each ctrl In Me.Controls
If ctrl.ControlType = acCheckBox Then
If ctrl.Value = True Then


What I'm needing is to assign the label that is associated with the checkbox to a variable.

Here's the code I was using to assign the name of the checkbox to the variable, but I need the label instead.
strcheckboxname = ctrl.Name

[ajetrumpet]

all controls have different names.

you would benefit a lot more by naming your checkboxes sequentially and naming the associated labels similar to that, perhaps preceeded with an "L" or something. for instance "checkbox1" and "Lcheckbox1". and so it becomes a piece of cake to assign your label name to a variable.

your code then becomes this:

for each ctl in me.controls
   if ctl.controltype = accheckbox then
      if ctl.value = -1 then
         strcheckboxname = "L" & ctl.name
      end if
   end if
next ctl

hence, a simple loop.