Filtering a SubForm

  • Thread starter Thread starter Doug
  • Start date Start date
D

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??
 
Found the answer if anyone else is interested -

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

Thanks Pavel for posting this elsewhere in the group.
 
Back
Top