when the value in the combo box on a subform (cboUnits_LampPowerTab) is updated
I want the value shown in a combo box on the parent form to also update (cmbUnits)
the value is the same field / record shown in 2 locations; they are a redundant entries for the convenience of the user
the code that i thought would work is:
Code:
Private Sub cboUnits_LampPowerTab_AfterUpdate()
Me.Parent!cmbUnits.Requery
End Sub
but the parent field does not update
(some of you may have noticed that soon as i get near parent form / subform code... i'm a complete "don't get it" .. so my apologies in advance ...it's just this wall against knowledge that i seem to have =: -(
maybe it has nothing to do with parent / subform at all? do i need some sort of repaint (?)
many thanks in advance,
mark