SUBFORM CODE

[NEOFYTOS]

Hello my name is Neofytos

i have a form with a TabControl with five pages.
every page have a subform.
i want to write a code in order to make a condition between a field in the
subform and a field in the Page. Both fields are in the same page .
where i have to put the code .
i tried to put the code in the subform but i could not find the other field
in the page.
i wait for help

 

[pietlinden]

Hello my name is Neofytos

i have a form with a TabControl with five pages.
every page have a subform.
i want to write a code  in order to make a condition between a field inthe
subform and a field in the Page. Both fields are in the same page .
where i have to put the code .
i tried to put the code in the subform but i could not find the other field
in the page.
i wait for help
 --
THANK YOU

Straight from one of the old masters...
Forms: Refer to Controls on a tabbed form
Author(s)
Keri Hardwick


(Q) How do I refer to a control found on a tab page when I'm using
a tabbed form?

(A) The tab control has no impact on the syntax for referring to a
control. To refer to a control on the main form, you simply use
[Control name].

To refer to a property of a subform on a tab page, you use:

[Subform Control Name].Form.Property

To refer to a control on a subform on a tab page:

[Subform Control Name].Form![Control Name]

And, to refer to a property of a control on a subform on a tab page:

[Subform Control Name].Form![Control Name].Property