updates

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I would for the date field to track the latest update made to a record.
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Query design 0
Searching/Filtering Form by Date Calendar: Week Beginning... 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Defaulting fields 1
Date last modified for a field 3
Enter date/time into table 2
Form_Update event (Before or After) 3
modified update 2

Back
Top