record time a field is changed - possible?

  • Thread starter Thread starter Tim Dixon
  • Start date Start date
T

Tim Dixon

Hi there,

Is it possible to record the time/date when a particular field is changed?

At the moment it sets a time/date when a 'NEW' record is created, but I want
it to fill another field to show the last time it was modified

Is this possible? if so how?


Thanks,


Tim.
 
Assuming you are using a form:
Create a control which has its controlsource set to the modTime field in the
underlying table,
In the Form_BeforeUpdate event, set the controls value to the current
data/time:
e.g.
Private Sub Form_BeforeUpdate()
Me.txtModTime = Now() 'Will insert the current date/time
Me.txtModTime = Date() 'Will insert the current date
Me.txtModTime = Time() 'Will insert the current time
End Sub

N.B. You will need to use one of the above...
 
Back
Top