Counting additions to records

[jaycee]

I am trying to set up a counter on a form that lets me
know how many times that record has been amended or added
to, using Access 97.
Any ideas would be grateful
Thanks

 

[chas]

Hi Jaycee,

you first of all have to add a number field to the
underlying table to store the information and then add
this new 'field' to the form. You could then use the
BeforeUpdate event of the form to increment the existing
value in the 'field' using either VBA or a SetValue macro
action. VBA is simplest (to me) and can be something like:

[MyCounterControlName] = [MyCounterControlName] + 1

hth

chas