Auto entry of a field based on another field.

  • Thread starter Thread starter Grace
  • Start date Start date
G

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.
 
Grace,

Try:

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

HTH

Steve
 
Back
Top