While the OnDataChange event is called when a record is changed, it is called several times for each change and then each time a piece of data changes in any of the fields. Certainly there has to be a more focused way to do this. Any suggestions?
Have you looked at the OnUpdateData event? This only fires in response to arecord about to be posted to a table, not every time something is changed.