How do you reference a control on a parent form from a subform?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you reference a control on a parent form from a subform?

My subform is not tied with a unique identifier. The sub form is like a
valid value table and I want to update a table that need the parent forms
uniqueID.
 
My subform is not tied with a unique identifier. The sub form is like a
valid value table and I want to update a table that need the parent forms
uniqueID.
Click to expand...

Normally, you would have the parent form related to the child form using the
Master Link field and Child Link field; they'll be equal in value so you can
just refer to the form control containing the child link field.

Failing that...

Parent!controlname

refers to the control named controlname on the parent form.

John W. Vinson [MVP]
 
I aware that is is a bit backwards but this valid value table can't be
associated with the parent. It validates and populates the table that does.

I'll give the Parent syntax a go thanks.

Thanks
--
Thanks,

JSY
MTTrader
 
Perfect Thanks

--
Thanks,

JSY
MTTrader


John W. Vinson said:
Normally, you would have the parent form related to the child form using the
Master Link field and Child Link field; they'll be equal in value so you can
just refer to the form control containing the child link field.

Failing that...

Parent!controlname

refers to the control named controlname on the parent form.

John W. Vinson [MVP]
Click to expand...
 
Back
Top