i want to trigger an event when going away from a record (to the next record) in a continues form or subform.
Before update doesn't work because many times i'm doing an update on a control even the user is on the same line (record).
On the Forms header we have a On UnLoad event that works fine but not on the details.
Is there a way to know when a user is in subform and going to the next line, i should be able to trigger a function.
I want to able to tell SQL that this record is done and make a copy into a log file (only once)
thanks in advance