Field to reflect last update of record

  • Thread starter Thread starter deb
  • Start date Start date
D

deb

I would like to have a field assoicated with each record
that would show the date of the last update of any of the
fields of that record. How would I state that and where
would I place the code? Thanks
 
deb said:
I would like to have a field assoicated with each record
that would show the date of the last update of any of the
fields of that record. How would I state that and where
would I place the code? Thanks
Click to expand...

In the BeforeUpdate event of the form...

Me.RevisedOn = Now()

All edits would have to be done using this form or other forms that include
the same code.
 
Asked and answered all the time. Do a search for "timestamp"

Please search a newsgroup prior to posting a new thread. That is the whole
reason that messages (and responses) are saved in the newsgroup.

Rick B
 
Thank you, Rick. I have looked at other timestamp posts and didn't see one
that applied to this case. I don't want the timestamp to reflect when
changes have been made to a form, but when changes have been made to any
field of a particular record. I can have the date/time field default =Now(),
but would that reflect the date a record was added or any change in that
record's fields? I apologize for not stating my question better. Thanks.
 
debpep said:
Thank you, Rick. I have looked at other timestamp posts and didn't see one
that applied to this case. I don't want the timestamp to reflect when
changes have been made to a form, but when changes have been made to any
field of a particular record. I can have the date/time field default =Now(),
but would that reflect the date a record was added or any change in that
record's fields? I apologize for not stating my question better. Thanks.
Click to expand...

My suggestion would update the timestamp whenever any part of a record was
changed *using the form to make that change*. It does not mean when the form
itself is changed.

I meant to convey that if the table is edited directly then there is no way to
capture that and update the timestamp. It has to be done through a form or
query that includes a method to update the timestamp explicitly added to it.
 
Back
Top