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

[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.

 

[John W. Vinson]

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.

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]

 

[Guest]

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

 

[Guest]

Perfect Thanks

--
Thanks,

JSY
MTTrader

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]