If that's the case then find the audit threads in this forum and use that code.
From memory what it does, it look at each controls "old value" and compare it to the current value if the value has changed then the code records the fact in an audit table. You would just need to change this code to fire when your forms on close event operates. However it will only record changes to the last record shown in the form.
So I think you should still provide some more detailed explanation of what you are trying to do.