Reference a txtBox in subform NavigationPanel

[npa3000]

Hello,



I currently have a Navigation Panel (MainNaviForm) and a subform(CommisionNaviForm) that loads every time i hit the corresponding button in the NavigationPanel.

I want to run an sql query that takes as parameter a txtBox in CommisionNaviForm, so i use this: [Forms]![MainNaviForm]![CommisionNaviForm].[Form]![txtSupplier] but it doesn't work.

What do you suggest?

[June7]

By 'Navigation Panel (MainNaviForm)' do you mean a Navigation Form? And by 'button in the NavigationPanel' you mean a form listed in Navigation Panel?

Referencing a subform requires referencing the subform container control. I always name this control different from object it holds.

In a Navigation Form, this subform container is assigned a default name of NavigationSubform, so try:

[Forms]![MainNaviForm]![NavigationSubform].[Form].[txtSupplier]