Subform in a page

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

nebbia - 08 May 2005 01:18 GMT

I need to reference a control in a subform on a page(tab) in a form. I can't
find the right way to identify the page or is it even necessary

Reply to this Message

Douglas J. Steele - 08 May 2005 01:24 GMT

The fact that the control's on a tab doesn't matter: its name has to be
unique to the form, so you simply refer to it by name.

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

>I need to reference a control in a subform on a page(tab) in a form. I
>can't
> find the right way to identify the page or is it even necessary

Reply to this Message

John Vinson - 08 May 2005 03:00 GMT

>I need to reference a control in a subform on a page(tab) in a form. I can't
>find the right way to identify the page or is it even necessary

It's not: the syntax uses the Name property of the Subform control,
and of the control on the subform; the tab page or tab control are not
used. Just

Me!subformname.Form!controlname

whether the Subform is on a tab page or not.

Note that subformname is the Name property *of the Subform control*,
the box containing the form - not the name of the form within that
box. The names might be the same but they might not!

John W. Vinson[MVP]

Reply to this Message