How do you reference a control on a parent form from a subform? - ADO DAO RDO RDS

On Wed, 22 Aug 2007 23:28:01 -0700, MTTrader <MTTrader> wrote:

>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]

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


"John W. Vinson" wrote:

> On Wed, 22 Aug 2007 23:28:01 -0700, MTTrader <MTTrader> wrote:
>
> >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]
>

Perfect Thanks

--
Thanks,

JSY
MTTrader


"John W. Vinson" wrote:

> On Wed, 22 Aug 2007 23:28:01 -0700, MTTrader <MTTrader> wrote:
>
> >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]
>