Autodate on a save record command

[flying linus]

I have a field on the form that is suppose to indicate when the last edit to the record occured. I was trying to get it to fill in the date on the users machine when the save record command button was depressed. How would I do this?

 

[ghudson]

Use the forms BeforeUpdate event.

Me.YourLastEditDateTextBox = Now()
Me.YourLastEditedByTextBox = Environ("UserName")