Multiple Subforms

[steve1111]

Hello,

I have a navigation form and one currently working query based on text boxes on a form buried in 2 levels of subform.

[Forms]![frmMain_toplg]![Subform1].[Form]![NavigationSubform].[Form]![Trans Sup cbx rec] that works in one of my main navigation buttons.

but then on another button i have a similar setup for another qryManagers Log
[Forms]![frmMain_toplg]![Subform1].[Form]![NavigationSubformTS].[Form]![TScbx] - However this will not pull in th data when i requery. If i take out the parameters the query loads fine with all records. I am stumped as the top query works elsewhere in the navigation form.

Am i missing something - sorry I dont think i have work permissions to upload the database.

Thanks for any help

 

[steve1111]

Update: I have the query working using
[Forms]![frmMain_toplg]![SubForm1].[Form]![NavigationSubformTS].[Form]![Managers Log Query]![MLTScbx]
I needed to reference another form.

However, i really want to put on the form Managers Log Nav form a cbx "mlcbx" and a subform "mlctrl" where the cbx is the control source and after update it loads the form from the mlcbx into the subform. I have all that working, i just lose my query parameters when i move Managers Log Query form into that additional "mlctrl" subform. I guess i am just having a hard time grasping nesting subforms to run a query.

Thanks for any pointers