write over code

[kagawa]

I have created a module in Microsoft Access which is set to display the date a particular record was last updated. Currently the code adds this new information to the already existing information. What I would like is for this new information to replace the already existing information so that the only information in that field is the latest information. Any help would be greatly appreciated. Thanks.

 

[R. Hicks]

You should do this using the forms' "On Before Update" event.
This event will only trigger if you are all on a new record or if any data is altered in an existing record.

HTH
RDH