G
Guest
I would for the date field to track the latest update made to a record.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
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
Private Sub Form_BeforeUpdate(Cancel As Integer)
If (Me!DateChanged) <> date Then
Me!Datechanged.Value = date
End If
Armin_A
G
Guest
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.
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.
J
Jim Evans
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
Properties sheet, Event Tab. Change "DateChanged" to the name of the field
you want to update.
Jim Evans