Query Not Working From Navigation Subform (1 Viewer)

[Kheribus]

Hello,

So I have a query that references data from my form 'Change Trips'. It works inside of the form, but when I open up my navigation form and navigate to the link that references the 'Change Trips' form as it's navigation target (ie when I access the 'Changed Trips' form through the navigation interface, my queries aren't working, and I am getting Enter Parameter Value dialogues.

Do I need to rename my criteria expressions in the query to reference the form data from something like: [Forms]![Change Trips]![tripName] to ... something else? I see the navigation subform option in intellisense and if I keep going deeper I dont recognize any of the fields.

Thanks,
B

 

[TJPoorman]

You need to reference the full path to your subform.
Should be something like [Forms]![NavForm]![NavigationSubform].Form![tripName]

 

[Kheribus]

Awesome it worked. It was on a subnavigation menu so it was:

[Forms]![Navigation Main Menu]![NavigationSubform].[Form]![NavigationSubform].[Form]![Combo4] .... haha. Also my Combo4 did not intellisense in, which made it tricky.

Thanks for the help!