Hi, looking for some help on this.
I have a navigation form [Main] with a subform [NavigationSubform]. The subform has 2 combo boxes [cboAgent] [cboProject]. Ultimately, I would like my selection in cboAgent to requery cboProject after update.
I have done this before outside a navigation form by using this on the afterupdate event of cboAgent;
Me.cboProject = Null
Me.cboProject.Requery
Me.cboProject = Me.cboProject.ItemData(0)
But this does not work in the navigation form. I tried referencing the subform directly like this
Forms!Main!NavigationSubform!cboProject = Null
but that also has zero effect.
Any help would be great!
Thanks
I have a navigation form [Main] with a subform [NavigationSubform]. The subform has 2 combo boxes [cboAgent] [cboProject]. Ultimately, I would like my selection in cboAgent to requery cboProject after update.
I have done this before outside a navigation form by using this on the afterupdate event of cboAgent;
Me.cboProject = Null
Me.cboProject.Requery
Me.cboProject = Me.cboProject.ItemData(0)
But this does not work in the navigation form. I tried referencing the subform directly like this
Forms!Main!NavigationSubform!cboProject = Null
but that also has zero effect.
Any help would be great!
Thanks