Auto entry of a field based on another field.

[Grace]

I have a field on a form [Closedby]. This field is a
combo box that looks at a table containing a list of
names. Is there an easy way to have another field
[Dateclosed]automatically log a date/time when a value is
entered into [Closedby]?

Thank you.

 

[SteveS]

Grace,

Try:

Private Sub ClosedBy_AfterUpdate()
If IsNull(Me.ClosedBy) Then
Me.DateClosed = ""
Else
Me.DateClosed = Now()
End If
End Sub

HTH

Steve