>>>How should we record a value automatically for particular values that is changed or updated in collection of information. Also how should we update such details automatically.
According to your description, you could use the After Update event to perform any actions that you want to occur when a record is changed. Common uses for the After Insert include enforcing business rules, updating an aggregate total, and sending notifications.
You can use access a the previous value in a field by using the following syntax.
[Old].[Field Name]
For more information, click
here to refer about After Update Macro Event
and
here to refer about Create a data macro
