Filtering a SubForm

[Doug]

I have a form which contains a tab strip control and some other controls on
it in addition to a subform. The subform is used to display various forms
corresponding with the tab strip on the parent form (ie - click on the
"Confidential Information" tab and the "Confidential Information" form is
loaded into the subform).

I have used filtering embedded within the subforms being loaded into the
subform control 'on load' and 'on current' to create a filter based on a
global variable and then refreshing the parent form. This does a decent job;
however, it would seem there should be a way to walk the tree from the
parent to the controls and properties on a subform.

Ultimately, I have a combobox on the parent form - when that selection is
made, the id populates the value of a global variable. That global variable
is used as teh basis for the filter. I should then be able to do something
like -

me.chdPeople.Filter = "some filter info"
me.chdPeople.FilterON = true

I am abviously missing some syntax to get from the subform control on the
parent form to the controls and properties of the source object of the
subform.

Any ideas??

 

[Doug]

Found the answer if anyone else is interested -

Me.Subform.Form.Controls("ControlName").Property = Value

Thanks Pavel for posting this elsewhere in the group.