reference a tab control?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Terry - 02 May 2005 05:07 GMT

I have a form with a tab control with a page with a subform control. How do
I reference a field in the subform from the parent form?

I know that it's form!subformctl.form!field, how for a tab?

Reply to this Message

Allen Browne - 02 May 2005 05:40 GMT

The tab control is not part of the reference.

Just use the same thing as if the subform is sitting directly on the main
form, i.e.:
=[subformctl].[form]![field]

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

>I have a form with a tab control with a page with a subform control. How
>do I reference a field in the subform from the parent form?
>
> I know that it's form!subformctl.form!field, how for a tab?

Reply to this Message