I have set of cascading combo boxes that query a table and uses criteria this will function without an issue when it's not in a navigation subform. So I have tried to update the query to go through the navigation form and it is not working.
IntelliSense works up to [Forms]![frmNavigation]![btnNavigationButton]
Then when trying to select FORM it does not come up so I manually enter the reset.
.[FORM]![cboValue]
I have also attempted other syntaxes like the ones mentioned in this link:https://bytes.com/topic/access/insights/599404-referring-items-sub-form
Also, have rebuilt the navigation form from scratch and have run a compact & repair.
I have spent hours searching and trying the different solutions on here and google and the standard ones I have been coming up.
for some reason, the [btnNavigationButton] does not have .Form property is am not sure if there some property that needs to be manually set to get this to work
Thank you for your time.
The user that left a comment answered the question for me. I was setting it to the wrong controller i was selecting the button controller and needed to select NavigationSubform
controller appreciate the everyone feedback.