Capture Table and Field Name

[TotheRiver]

I want to create a VBA procedure that will record changes made to the data, like an archive. I would like to have it record the table and field name in addition to the old and new data when any change is made to the data. In this way, I can keep all changes in one "archive table" and reference it as I desire. I'm sure this can be done, as this is what the new "name auto-correct tracking log" does in Access 2000. Questions are: How do I make a procedure that runs after any update to any field without using the "after update" event for each field? How do I reference the table and field name in visual basic and make that a piece of "data" now? Any ideas of where to start are appreciated.
Brian

 

[MichaelRed]

Second time today. faq181-291
MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over