Limit number of times arecord is updated

Is it possible to limit the number of times a record is updated.

Of course i know how to stop it being updated once it exists but i want to fix the updates to say 2 (the original entry and 1 change)


The records are updated in a form text box.

Thanks
SweetingAAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
i'll suggest to use Audit or time stamping of records changed or deleted

see this links

http://allenbrowne.com/AppAudit.html


http://support.microsoft.com/?kbid=197592
0
 
Rey Obrero (Capricorn1)Commented:
you will need counters to do this, but may i ask why you need to do this?
0
 
SweetingAAuthor Commented:
I am a natural sceptic!

Anyone can make a mistake and have to change a record, if someone changes the same record twice i would be suspicious of their reasons so i want to prevent it happening.

Regards
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.