Box that shows when a form was last updated

[jaybo]

I wondering if anyone knows of an automatic way that changes can be tracked on a form.

Ex. The last time a record was updated in that specific form

 

[jrjr]

Sure, just include a text box with either:
now()
or Date()
as the default value
Store the value in a new field in your table

 

[ghudson]

Sure, just include a text box with either:
now()
or Date()
as the default value
Store the value in a new field in your table

That will only create a date stamp for when the record was created.

You need to use the forms BeforeUpdate event to fill a text box [txtLastModified] with the =Now() of a "LastModified" field in your table.

Me.txtLastModified = Now()