Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 MS Access
 Counting the number of changes

Author  Topic 

vgunas1
Starting Member

18 Posts

Posted - 2003-05-15 : 09:22:22
Hi,

I have a form which has the following fields:
ID
Title
Subject
Location.
Everytime the user changes/modifies this information I want to be able to count it. i.e counter for changes.
Can anyone let me know as to how I can do this?

Thanks!

GreySky
Starting Member

20 Posts

Posted - 2003-05-15 : 10:41:05
Use the AfterUpdate event for the field to increment the counter.

You may wish to compare it against the .OldValue to ensure it actually changed.

Go to Top of Page
   

- Advertisement -