After Subform Update, Check Box on Parent Form True

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I was wondering if the following is possible?

My subform (fsubSupplier) has a "Price" field, which once that is filled
in/updated I want a checkbox (Inv2006) on my main form (frmPartDetail) update
to true.

I know I have to put the code in the After Update of my "Price" field but
not sure where to go from there.

Can anyone help me?

Thanks Kindly
Gabby Girl
 
You will need to do this in two places.
First, in the After Update event of the Price control (field)
If Not IsNull(Me.Price) Then
Me.Parent.Inv2006 = True
Else
Me.Parent.Inv2005 = False
End If

or

Me.Parent.Inv2006 = Not IsNull(Me.Price)

You will need the same code in the Current event of your sub form.
 
Back
Top