Put a value in a sub form from the main form

[UT227]

I have a form [frmSchMonthly]. It has a combo box [cboMonthListID]. The form has a sub form [frmSchMonthlySubF]. The sub form has a field [SchMonth]. I want to fill [SchMonth] with information from the form's combo box [cboMonthListID]. I used: Forms!frmSchMonthly!frmSchMonthlySubF!SchMonth = Me.cboMonthListID.Column(1)
It took me to the debugger.
How do I get that value in the field I need it in?

[mike60smart]

Hi

IN the subform you can use an Unbound Control in the Header and use =[Parent]![cboMonthListID.Column(1)]

Then name the Control "Monthly"

Then on the after Update of the First Control on the Subform you can use this:-

Me.[SchMonth] = Me.[Monthly]