Looping through checkboxes

[HansBades]

I have some code where I am looping through checkboxes on a form where each checkbox name represents a field name from another form. If the checkbox is checked, the code is designed to hide that field in the other form. This works fine if I state the name of the control explicitly. But when I loop through each checkbox is designated as the current "ctl" or "ctl.name", I get a syntax error. I think this is perhaps because the ctl it is supposed to hide is in another form. Is there any way to get around this? Thanks!

Dim ctl As Control
For Each ctl In Me.Controls
If ctl.ControlType = acCheckBox Then
If ctl.Value = True Then
Forms!SKUWorkOrder_SubformWODetails.Form.ctl.Name.ColumnHidden = True
End If


End If
Next ctl

[ranman256]

bad syntax, it may be:

Forms!SKUWorkOrder_SubformWODetails.Form.contols(ctl.Name).ColumnHidden = True

[Micron]

I'd say that the ctl object doesn't exist on the other form so you can't refer to it as an object. First see if you got the form reference right
Msgbox Forms!SKUWorkOrder_SubformWODetails.Form.name

If that looks good, then try assigning ctl.Name to a variable and use that as in
Forms!SKUWorkOrder_SubformWODetails.Form.Controls(strName).ColumnHidden = True

[moke123]

.columnhidden applies to datasheets not controls. Controls have a visible property.

[Micron]

I took it that this is about a datasheet form? You can hide a datasheet column by referring to the control name. Try this in your immediate window on an open datasheet form:

Forms!FormNameHere.txtBoxNameHere.ColumnHidden = True

EDIT - from documentation
The ColumnHidden property applies to all fields in Datasheet view and to form controls when the form is in Datasheet view.