Call a subform event from the main form

[bonecone]

I use the onLoad event of the parent form to select the first item in a combobox of a subform. If I use the syntax



Form_frmSubformName.cboControlName.ListIndex = 0

I get an error message about the improper use of the ListIndex property. If I use the syntax

Form_frmSearch.cboField = Form_frmSearch.cboField.ItemData(0)

it selects the first item in the list but it fails to trigger the onChange event of the combobox. I know how to manually call an event of a control within the same form, but how do you call the control event of a subform?

[Bob Fitz]

Try:
Me.SubFormName.Form.CtrlName_Change
Change the names in Red

Also change the declaration of the subform control from Private to Public

[bonecone]

Ok thanks! That worked.