Updating subform with a control on main form

[tsison7]

I have a subform in DS view and I'd like to be able to hide certain columns
with an option box on the main form.

I know how to hide a column on a form in DS view with "columnhidden". But
how can I dynamically update the subform with my option box?

 

[Brendan Reynolds]

I have a subform in DS view and I'd like to be able to hide certain columns
with an option box on the main form.

I know how to hide a column on a form in DS view with "columnhidden". But
how can I dynamically update the subform with my option box?

Private Sub fraTest_AfterUpdate()
Me.sfrTest.Form.Controls("txtTest").ColumnHidden = (Me.fraTest.Value =
2)
End Sub

In this example, "fraTest" is the option group, "sfrTest" is the name of the
subform control, and "txtTest" is the name of a text box on the form
contained within the subform control. The option group has values 1 for Show
and 2 for Hide.