I have a subform whose SourceObject is set depending on the subform
the user wants to see. One of the subforms has a subform within it.
I'm trying to requery a combobox in the inner subform. How do I refer
to that combobox? I've tried the following:

NOTE: (frmRegistrations is the parent form,
subfrmRegistrations_People is what the SourceObject is set to,
subfrmRegistrations_Addresses is the subform within
subfrmRegistrations_People):

Forms!frmRegistrations!
subfrmRegistrations.subfrmRegistrations_Addresses! cboCity.Requery (I
get an error message that "Object doesn't support this property or
method"

Forms!frmRegistrations!subfrmRegistrations.Form!
subfrmRegistrations_Addresses!cboCity.Requery (error "Microsoft
Office Access can't find the field 'subfrmRegistrations_Addresses'
referred to in your expression.")

Forms!frmRegistrations!subfrmRegistrations_People. Form!
subfrmRegistrations_Addresses!cboCity.Requery (error "Microsoft Office
Access can't find the field 'subfrmRegistrations_People' referred to
in your expression.")

Thanks for any help or advice.

Forms!frmRegistrations!subfrmRegistrations
..FORM.subfrmRegistrations_Addresses.FORM!cboCity. Requery

The above assumes that the subform CONTROLS are named subfrmRegistrations and
subFrmRegistrations_addresses. The control may have a different name then the
form it contains.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

On 11/3/2010 11:27 AM, emanning wrote:

On Nov 3, 10:34*am, John Spencer <JSPEN... (AT) Hilltop (DOT) umbc> wrote:
Thanks. I modifed it per your suggestion. Now I get the error
message "Application-defined or object-defined error". I noticed that
cboCity does get requeried if I get off the current record and back
on. So now I'm wondering if this is really the correct coding that is
needed. Maybe I should try something else besides Requery??