MS Access: query criteria in subform of a navigation form

0
votes

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.

1
ms-accessvbams-access-2010acc
I think the issue might have been since I was using NavigationLinkSource. So i am trying to use Subform wizard and see if the relationships will work that way. – William Griffiths
Is btnNavigationButton name of the navigation control? Access usually names it NavigationSubform. Don't reference the buttons (tabs). – June7
Edit question to show the SQL of dependent combobox. All comboboxes are on same form? Probably don't need full path. SELECT City FROM Cities WHERE State=[cboState]; – June7
btnNavigationButton is the tab button name on the navigation form I will take a look at NavigationSubform – William Griffiths

1 Answers

0
votes

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.