DateTime stamp for a field, not a record.

[TimE]

Sorry if I may have missed it or searched incorrectly.

I have an access frontend to a SQL database. I can get the datetime stamp to work when a new record is created, but I would like to also datetime stamp AND be able to "user" stamp when a single 'field' has changed within the same record.. Where do I need to look or what should I search for to get me started?

Again, thanks for ANY assistance.

 

[ejstefl]

Do a search for "Audit Trail."

 

[DB7]

In the AfterUpdate event, of the field, put , txtField = Date

Even easier, directly from the properties dialog, Events tab, for the after update event put, =Date()