requerying a control on a sub-form

[NielsE]

I am trying to have the combobox: Region, to requery after update the
combobox CountryName in a subform that is bound to the TabCtl23 (tabcontrol)
on the main form. I think I have used all diffenrent kinds of combinations
for the the following syntax, but it does not work. Please help.

Private Sub Region_AfterUpdate()
[TabCtl23]![subfrmProcountry]!CountryName.Requery
End Sub

Thanks in advance.
Niels

 

[John Vinson]

I am trying to have the combobox: Region, to requery after update the
combobox CountryName in a subform that is bound to the TabCtl23 (tabcontrol)
on the main form. I think I have used all diffenrent kinds of combinations
for the the following syntax, but it does not work. Please help.

Private Sub Region_AfterUpdate()
[TabCtl23]![subfrmProcountry]!CountryName.Requery
End Sub

Thanks in advance.
Niels

The tab control is COMPLETELY IRRELEVANT. It is not used in
referencing controls.

If the Name property of the subform is sbfrmProcountry (that is, the
name of the *box*, not the name of the form within that box) use

Me!sbfrmProcountry.Form!CountryName.Requery

The .Form! is supposedly optional but I find it helpful, at least in
understanding the code.

John W. Vinson[MVP]