Enter date for only records that change

[amerifax]

We have a field that should get the current date only if record is changed. The date field is called "change".

We tried the following in Field Properties - After UpDate. No go.
2010Master![change]=Date()

2010Master![change]=Date()

I would think it would be some kind of an event.

Bob

 

[SmallTime]

Try

If Me.Dirty = True then
Me.change = Date()
Me.Dirty = False
end if

 

[boblarson]

Put it in the form's BEFORE UPDATE (it only fires if it is a new record or something has changed) event. And you can check to see if it is a new record if you don't want it to be put in there for that:

Private Sub Form_BeforeUpdate(Cancel As Integer)
   If Not Me.NewRecord Then
      Me!Change = Date
   End If
End Sub