I am struggling to refer to a control that is buried within 2 navigation forms. I have searched everywhere and tried different solutions but to no avail. This is the structure:
Top Form = "Main"
Navigation Subform = "NavSubForm"
2nd Navigation Subform = "TabSubForm"
Form holding the control = "frmSubForm"
Control on frmSubForm = "cboAssets"
The recordsource of "frmSubForm" is a query that looks at "cboAssets" in it's header; if it is null, then it pulls up all the records. If there is a choice in "cboAssets" it filters the records. I can get this to work fine when there is only 1 navigation form:
[Forms]![Main]![NavSubForm].Form![cboAssets]
However, I have been unable to get to this control when there is the additional subform ("TabSubForm") involved. I've tried:
[Forms]![Main]![NavSubform]![TabSubForm].Form![cboAssets]
and various combinations but to no avail. I think I understand the syntax, but I must be missing something obvious. If someone could please help, I would be forever grateful, but I need 2 things:
(1) How to reference this control &
(2) How to requery the "frmSubform"
Thanks a million in advance,
Rod
Top Form = "Main"
Navigation Subform = "NavSubForm"
2nd Navigation Subform = "TabSubForm"
Form holding the control = "frmSubForm"
Control on frmSubForm = "cboAssets"
The recordsource of "frmSubForm" is a query that looks at "cboAssets" in it's header; if it is null, then it pulls up all the records. If there is a choice in "cboAssets" it filters the records. I can get this to work fine when there is only 1 navigation form:
[Forms]![Main]![NavSubForm].Form![cboAssets]
However, I have been unable to get to this control when there is the additional subform ("TabSubForm") involved. I've tried:
[Forms]![Main]![NavSubform]![TabSubForm].Form![cboAssets]
and various combinations but to no avail. I think I understand the syntax, but I must be missing something obvious. If someone could please help, I would be forever grateful, but I need 2 things:
(1) How to reference this control &
(2) How to requery the "frmSubform"
Thanks a million in advance,
Rod