updates

  • Thread starter Thread starter Guest
  • Start date Start date
I've used following code to track changes:

Private Sub Form_BeforeUpdate(Cancel As Integer)
If (Me!DateChanged) <> date Then
Me!Datechanged.Value = date
End If

Armin_A
 
l am a developer Please tell me how to do this in the property fields. There
is a way to do it there. I have done it before but I can not remember how I
did it.
I develop the database using tools. But thanks Armin. Can someone help me
in the property fields. I would like for the " last visit date" field to
show the date every time a change is made to a record. But when a user open
a record to view only then the date should not change.
 
He just did. He gave you the code for the BeforeUpdate Event. on the
Properties sheet, Event Tab. Change "DateChanged" to the name of the field
you want to update.

Jim Evans
 
Back
Top