Referring to control on subform

[Joseph Greenberg]

I have a parent form named fMemberInfo
with a tab control called tabSubforms
with a subform called fYInfoSubform
with a combobox call cboSeqNo

I would like to requery the combobox on the parent form's "OnCurrent" event.

How do I refer to the comboxbox?

 

[John W. Vinson]

I have a parent form named fMemberInfo
with a tab control called tabSubforms
with a subform called fYInfoSubform
with a combobox call cboSeqNo

I would like to requery the combobox on the parent form's "OnCurrent" event.

How do I refer to the comboxbox?

The tab control is irrelevant in this context. What you need is the Name
property of the Subform *CONTROL* on fMemberInfo - this might or might not be
the same as the name of the form object within that control. If the Subform
Control is in fact named fYInfoSubform, use

Me!fYInfoSubform.Form!cboSeqNo.Requery

 

[Joseph Greenberg]

Thanks, this did the trick - had to dig to find the name of the subform
control, but find it I did.