Date Time Stamp in Table

B

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
 
D

Daniel

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()
 
Top