Inputting date automatically and saving to table

[Rose]

Can anyone tell me how to automatically generate the date that a record was updated into a field and to save that date to a table. When I do it, it always shows the current date rather than the date that the record was updated.

Thanks

Rose

 

[KKilfoil]

I don't know if this is the best way, but what I do is use the AfterUpdate event for the appropriate controls of my form (I assume you would want to do this in a form since you posted to this forum) to write the current date/time to my WhenUpdated control/field.