Automatic date in current record afterupdate 2

[chrisjones99]

Hello,

Looking for a method to automatically update a field of my record with the current date and time after it has been modified..
-tried with setvalue but didn't work.

So basically i want the field to contain date & time of modification so i can use it later to see which record have been recently modified..

Thanks a lot for your help

Best regards,

chrisjones99

 

[hermanlaksko]

Place the code on the forms after update event, that should do the trick

Herman

They say that crime doesn't pay... does that mean my job is a crime?

 

[PHV]

In the BeforeUpdate event of the form:
Me![timestamp control] = Now()

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[chrisjones99]

Thanks for your answer herman,

the thing is i tried afterupdate event but probably don't have the right code...
can you help me with the code:

i tried to create a variable X and then affect the now() formula to this variable X, then tried to take the name of the field and affects the variable X to it but it wouldn't work..

Can you help ? Thank you very much!!!!

 

[chrisjones99]

Thanks PHV, this worked perfectly !!!!!!!!!

Many many thanks to both of you for your time..