Referring to a control on a Tabbed Frm

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Anthony Viscomi - 02 Mar 2007 16:13 GMT

I'm sure this question has been asked before; but I couldn't find any recent
posts.

I have a tabbed form and I want to refer to a value contained within another
field that resides on another tab; the current frm that is doing the
referring is acutally a sub-form.

Simply put; what is the sytax need to acheive this?
Thanks in advance!
Anthony

Reply to this Message

Douglas J. Steele - 02 Mar 2007 16:20 GMT

The presence of the tab control doesn't change anything. Even though the
controls are on separate tabs, their names still have to be unique, so you
simply refer to them by name.

From the subform, use Me.Parent.NameOfControl

Signature

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

> I'm sure this question has been asked before; but I couldn't find any
> recent posts.
[quoted text clipped - 6 lines]
> Thanks in advance!
> Anthony

Reply to this Message

George Nicholson - 02 Mar 2007 16:22 GMT

No special syntax is required. Address controls on a tab control as if they
were "on" the same main form as the Tab control, because they are. The tab
is just a display convenience.

(just try giving a control on page 2 of a tab the same name as a control on
page one or the main form. You won't be allowed to. Since they are all "on"
the same form, the names must be unique.)

HTH,

> I'm sure this question has been asked before; but I couldn't find any
> recent posts.
[quoted text clipped - 6 lines]
> Thanks in advance!
> Anthony

Reply to this Message

Anthony Viscomi - 02 Mar 2007 16:36 GMT

Thanks to all!

> No special syntax is required. Address controls on a tab control as if
> they were "on" the same main form as the Tab control, because they are.
[quoted text clipped - 16 lines]
>> Thanks in advance!
>> Anthony

Reply to this Message