How to change DateEdited in form to current date

[toni3]

I am trying to change the DateEdited field to the current date when any data changes in the record. The property in the form for the field has an input mask 99/99/000;0;_ and AfterUpdate is =Now(). The table Default for this field is the same. It isn't working. Any help?

 

[hymn]

shouldn't it be 00/00/0000;0;_

Hope this helps
Hymn

 

[toni3]

Thank you. I did change the input to zeros, but still don't get the change of date.

 

[jebry]

Hi!

You need to do this in code. In the form's Before Update event procedure use:

Me!DateEdited = Now()

hth


Jeff Bridgham
bridgham@purdue.edu

 

[toni3]

Thank you, thank you Jebry

The current date now works in the form!!

Toni

 

[jebry]

Hi Toni!

Quite welcome!




Jeff Bridgham
bridgham@purdue.edu