Hello all,
I have cascading combo boxes nested within subforms. I've managed to set the row source of the subform combo boxes such that they refer to the parent form combo box, but I am having trouble getting the requery in the After Update event of the first combo box to work.
I've tried using the Code Builder in the After Event field of the first combo box with derivations of lines such as these:
Parent Form = frmSite
Subform = subfrmLightDate
1st combo = cboSite
2nd combo = cboDate
cboDate.Requery
Me.cboDate.Requery
Me.subfrmLightDate.form.cboDate.Requery
Me.Parent![subfrmLightDate]![cboDate].Requery
and so on without any luck. The main error is "Method or data member not found" with cboDate highlighted. I don't understand why the parent form is not recognizing code related to subforms. The Link Child and Link Master Fields are both properly set up.
I'm working in Access 2016 and it automatically builds Embedded Macros in the After Update event of the first combo. When I use the code builder it erases those macros. I'm wondering if this is part of the problem?
Any advice is greatly appreciated!