VBA Generic Way to address a field
Posted on 2011-03-01
I am writing an audit trail for changes to tables etc (I know - reinventing the wheel. But at least its my wheel).
Take a table with 50 fields.
I want to do a comparison in each beforeupdate event such as ..
... If field1.oldvalue <> field1.value then ...
I am trying to minimise the code for obvious reasons.
Rather than repeat this above "IF" code I was wondering if it was possible to somehow just call a function that simple refers to the "current field".
In order words, I do not want to specify field names - I want the system to know that "current field" means the field that the "event" started from.
So if I was in field 25 and used a "BeforeUpdate" event - the system would know that "current field" meant field 25.
Is there such a facility??
Is this clear??