See attached - very very simple database.
Note the variant called "AllFields"
I want a new function to be called from Private Sub Form_BeforeUpdate.
This function will display the actual value in each field in the array "AllFields".
So, for instance, the function will display the name "Tom", "123", etc.
The function will display the "OldValue" and the current value of the field.
Could someone give me guidance as to how I can displays these values.
Actually, what I really need is the few lines of VBA to show these values.
Also, I am uncertain of any DIM statements in the function.