Capture all change in form

[mutley]

Hi

How Can I to capture all changes which were made fom ? as if it were an auditor


tia

[Arnoutdv]

What kind of changes do you mean?
Changes by the end user?
Or do you want know about the changes of the position, height, width of the form?

Can you explain in more words what you need?

[Phill.W]

If you just want to "notice" when a change is made to a field on the Form, use the *Changed events on the various Controls.

If you want a complete record of who changed what and when, then you need to be thinking about putting that into your Database and automating it through Triggers.

Why?
Because your application isn't the only way that people can change that data!

Regards, Phill W.

[techgnome]

True that... couple of lifetimes ago, we had a client claiming that some data was being changed unbidden... they were adamant that it was our app that was doing it... according to the app logs there was no trace of the change... so we slipped in some triggers to track changes on the important tables ... and what do you know... we started seeing changes from SQL Management Studio where someone was running scripts (which were tied back to the user that was making the claim about data changing!) and updating the data directly... Even better, the mysterious data changes suddenly stopped when we revealed what we knew (w/o explaining just how we knew) ... lid closed on that cookie jar...

-tg