Access value from a layered form for a query

[SltPhx]

Hello All,
I have a question regarding accessing a value from a "layered" form.

Main Form = FRM_Main

Has 4 tabs - Tab_1; Tab_2; Tab_3; Tab_Pends

Tab_ Pends - Navigation Target is FRM_Pends

FRM_Pends has 4 tabs
Tab_Pends1; Tab_Pends2; Tab_ActivePends

Tab_ActivePends - Navigation Target is FRM_ActivePends

Two control buttons - Result and Reason.

Drop down list of Reason depends on Result. If Result is 1 - Reason is A,B,C
Result is 2 - Reason is D,E,F
Reason drop down list is based on a query - and i need to access the value of Result in FRM_ActivePends to run the query.



I am not able to link Result to query accurately. When I use the form it asks me to enter the value for Result inspite of the value being in the form.

Please give me the correct syntax to access the form. I tried using NavigationSubform but nothing seems to work. I am missing something.

Thank you for all your help.

[June7]

You are using navigation form. Review: https://www.accessforums.net/forms/t...orm-32053.html

[SltPhx]

June 7,
I am not using a sub-form.

What I did was - used Tabbed control - and then connected that tab to a form - NavigationTargetName - I put my form name.
Would subform naming functions still work on this?

Does that make sense?

[June7]

NavigationTargetName is a property of navigation form button. A standard tab control is a very different animal. Don't think I've seen them used together before. However, ignore the tab control in referencing syntax, as if it weren't even there.

Supposed to include name of the navigation form container "NavigationSubform", assuming you didn't change it, in the referencing, like:

=NavigationSubform.Form.ControlName

Be aware that when switching between buttons of a navigation form, only the fields/controls of the form associated with the active button are available, as described in the referenced link.