Creating a Last Updated field for a form

Mike Smith

Registered User.
Local time
Today, 21:00
Joined
Sep 22, 2000
Messages
20
I have a form where users will generally view data but a few people might have to do edits. I want to capture the date and time of the last update for a given record. I set the form's After Update property to me.lastupdate=Now() but that locks me in a loop (everytime it updates the update field, it triggers another update event...) I could include the code above to every field but I'd rather not... Any ideas?
 
You should put the code in the BeforeUpdate event of the form.
 

Users who are viewing this thread

Back
Top Bottom