Date Time Stamp in Table

[Bob]

I have a field in my table called "Status' can I add another field to my
table that gives a date and time to when I changed the field in each record
in Status, [Status] being a text field options Active;Finished .........
thanks for any help with this..Bob

 

[Guest]

Yes, create another field, perhaps StatusDt

then in your form use the AfterUpdate event of the [Status] control to
update the [StatusDt] control's value with the current date and time

something like,

Me.StatusDt = Now()