Navigation Forms and paths? (Nav Form within Nav Form)

[offie]

I have a navigation form, with abother navigation form inside of it. Looks like:




I am having a hard time coming up with the path name for the text boxes and checkboxes

I read somewhere that is does not matter if there is a navigation form as a subform, and that it still counts as a subform so I tried to enter:

---

Like IIf([Forms]![Navigation Form]![NavigationSubform].[Form]![4Check]=True,"4*",Null)
Or Like IIf([Forms]![Navigation Form]![NavigationSubform].[Form]![MCheck]=True,"M*",Null)
Or Like IIf([Forms]![Navigation Form]![NavigationSubform].[Form]![JCheck]=True,"J*",Null)
Or Like IIf([Forms]![Navigation Form]![NavigationSubform].[Form]![SCheck]=True,"s",Null)
Or Like IIf([Forms]![Navigation Form]![NavigationSubform].[Form]![QCheck]=True,"Q*",Null)
Or Like IIf([Forms]![Navigation Form]![NavigationSubform].[Form]![ECheck]=True,"E*",Null)

Between [Forms]![Navigation Form]![NavigationSubform].[Form]![FYFrom]
And [Forms]![Navigation Form]![NavigationSubform].[Form]![FYTo]

---

But when I ran that, the queries came up empty with no parameter promt so I'm assuming something is wrong with the paths. How do I refer to these items?

Thanks!

[June7]

Does this help https://www.accessforums.net/forms/t...orm-32053.html

If you want to provide db for analysis, follow instructions at bottom of my post.

[offie]

Actually no but I figured out how to find the path of a navigation form inside a navigations form

Between [Forms]![Navigation Form]![NavigationSubform].[Form]![NavigationSubform].[Form]![FYFrom]
And [Forms]![Navigation Form]![NavigationSubform].[Form]![NavigationSubform].[Form]![FYTo]

Because in the subform/form there is another subform.form that has to be refrenced

Edit:
Also, to refresh in vba
[Forms]![Navigation Form]![NavigationSubform].[Form]![NavigationSubform].Requery