I want to develop a simple audit trail for one specific layout containing many fields. I don't want to use a plug-in and I don't want to populate every field with OnObjectEnter.
I use OnLayoutKeystroke to get the name of the field and its old value and then, when OnRecordCommit fires, I get the new value of the field and save of the modification in a related audit trail table.
This simple design works well except for getting the original old value of the field. Because OnLayoutKeystroke fires when each character is keyed in, I keep getting the last old value (the one associated with the last keystroke) with is different from the original old value (the one associated with the first keystroke ) of the field.
How can I avoid this situation without using OnOjectEnter in every field of my layout ?
Ce message a été modifié par : Jean-Marc Proulx