Counting amount of times a record is amended

[Jaycee]

I am trying to set up a form so that when the record is
amended a label with a count of times is changed.
Any ideas would be grateful
Using Access 97

 

[JohnFol]

Private Sub Form_AfterUpdate()
Me.txtCounter.Value = Me.txtCounter.Value + 1
End Sub

 

[HSalim]

You will have to add a column or two to the table
for example, you could timesModified and ModifiedDate,
and update these values each time an update is made.

Alternatively, you could add a history table that stores the previous values
You could then display the sum of amendments for this record on your form

This is a more complicated option but is used in situations where audit
trails are required.

HS