Form Subform Conditions

[indyaries]

Greetings,

I have a form (parent) called frm_DNO_Developmental Assignments
I have a subform called sbfrmDevelopmentalAssignments

On the parent form is a field called DevAssgn (Developmental Assignment). This textbox is Y or N.
On the subform is a field called End_Date.

What I would like to happen:
When an employee is displayed on the parent form, his Developmental Assignment information is displayed on a continuous subform. I would like to have the field DevAssgn change from Y to N and back depending on the date in the End_Date field of the subform.

Ex: If End_Date >= Date() Then DevAssgn = "Y"
Else DevAssgn = "N"

I don't know on which form (parent or sub) to put any applicable code. Also don't know if the code should be attached to any specific control, or to the form itself.

Also, on the subform I have the following code:
***********************************************
Private Sub Form_Current()

If Me![End_Date] > Date Then
Me![End_Date].ForeColor = vbRed
Else
Me![End_Date].ForeColor = vbBlue
End If

End Sub
***********************************************
This subform is a continous form. When I look at the information from the parent form it may show more than one developmental assignment for an employee in the subform. An employee can only be on one D.A. at a time. If an employee has completed a D.A., I would like the End_Date field to be Blue, otherwise the End_Date to be Red.

I hope that I explained this well enough to understand.

Thanks for any help that anyone may render.

Bob