I want to set an unbound control on a subform based on a value in an unbound combo box on the mainform.
The mainform, frmRecallPayQuantities, has a combobox cmbMonth.
The subform, frmDailyReportQuantitiesSummary, has an unbound textbox in the forms footer called txtMonth.
I'm trying to use the afterupdate event for cmbMonth to set the control source for txtMonth.
I've tried:
I get "#Name?" in the txtMonth field.
Been searching all morning for a solution.
Thanks.
The mainform, frmRecallPayQuantities, has a combobox cmbMonth.
The subform, frmDailyReportQuantitiesSummary, has an unbound textbox in the forms footer called txtMonth.
I'm trying to use the afterupdate event for cmbMonth to set the control source for txtMonth.
I've tried:
Me.frmDailyReportQuantitiesSummary.Form.txtMonth.controlsource = "Totals for the month " & Me.cmbMonth
I get "#Name?" in the txtMonth field.
Been searching all morning for a solution.
Thanks.