Navigation subform combo box afterupdate (1 Viewer)

RyLane

Registered User.
Local time
Today, 07:24
Joined
Feb 4, 2014
Messages
60
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
 

RyLane

Registered User.
Local time
Today, 07:24
Joined
Feb 4, 2014
Messages
60
Well I figured it.....looks like all I needed to do was change the dots to exclamation points. Was thinking to hard!

Me!cboProject = Null
Me!cboProject.Requery
Me!cboProject = Me!cboProject.ItemData(0)
 

Users who are viewing this thread

Top Bottom