how can i make it so that when the value of one field is 15 another field in same record automatically enters todays date?
thanks in advance!!

I assume you are either using continuous forms or are working with a
single form. AFAIK you can't do this type of thing when you are working
in datasheet mode.

Put some code in the AfterUpdate event that is similar to this :

Private Sub MyControl_AfterUpdate()

'-- set the other controls value to todays date --
Me.OtherControl.Value = Date()

'-- or, if the field isn't visible on a control --
Me!FieldName = Date()

End Sub

-[ Andrew Backer / abacker .@. comcast .dot. net ]-

jjrmy1 (AT) earthlink (DOT) net wrote: