How do I autofill a value in one field based on the value of anoth

[MatlGrl]

Access 2003
1) I have a form with the fields IYD, RevIYD, NeedDt and a chkbox named
"NonSupport".
I need for the check box to autofill to true when both the IYD and RevDt
fields are greater than the NeedDt.

2) On this same form I have another chkbox named "Closed" and a ClsdDt
field, I need the ClsdDt field to autofill with the date when the chkbox is
checked to true.

 

[Klatuu]

Question 1
Create a sub that you can call from the After Update event of the IYD,
RevDT, and NonSupport controls:

If Me.IYD > Me.NeedDt And Me.RevDT > Me.RevDt Then
Me.NonSupport = True
Else
Me.NonSupport = False
End If

Question 2.
In the After Update event of Closed:
If Me.Closed = True Then
Me.ClsdDt = Date()
End If