Hi-
I would like to add a field to the end of my table called Timestamp. I want this field to be populated with the current time if a record is updated. I know I can set the default to =Now(), but that only sets the time and date the record is created. If I go in an update this record, that time or date does not change. Is there a way to inset a time and date that would automatically change? If not, is there an easier way then to just type in the time and date manually? Any suggestions would be appreciated. Thanks!
Ian
I would like to add a field to the end of my table called Timestamp. I want this field to be populated with the current time if a record is updated. I know I can set the default to =Now(), but that only sets the time and date the record is created. If I go in an update this record, that time or date does not change. Is there a way to inset a time and date that would automatically change? If not, is there an easier way then to just type in the time and date manually? Any suggestions would be appreciated. Thanks!
Ian