Updating subform with a control on main form

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?
--
TIA

"tsison7" wrote in message
...
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?
--
TIA


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.

--
Brendan Reynolds