I come again to the well of knowledge...
Having a brain cramp here...
I display US address information, Address, City, State, and ZIP Code, in a simple user demographics form.
Prior to displaying the current record in the form, I set a variable, BeforeFullAddress, consisting of a concatenation of all of these items and also set a variable AfterFullAddress, also consisting of a concatenation of all of these items. Thus, when the user enters the record, both the before and after addresses are identical.
When the user make a change to any one of the four address items, AfterFullAddress is updated to reflect any/all changes made. Once the user is done with the current record, I want to compare BeforeFullAddress and AfterFullAddress. If they are different, I would then send an email notification to individual that need to know about the address change.
I have all of the code built to handle the changes and the email process. Where I'm drawing a blank is determining when to trigger the before/after check and kick off the email message if necessary. What I want to do is before the user leaves the current record (next record, previous record, any record move operation), I want to do the before/after comparison, send the email if necessary, then go to the next desired record. I can't seem to find an appropriate event to do this.
Can someone point me in a good direction on this?
Kind regards,
Ken
Having a brain cramp here...
I display US address information, Address, City, State, and ZIP Code, in a simple user demographics form.
Prior to displaying the current record in the form, I set a variable, BeforeFullAddress, consisting of a concatenation of all of these items and also set a variable AfterFullAddress, also consisting of a concatenation of all of these items. Thus, when the user enters the record, both the before and after addresses are identical.
When the user make a change to any one of the four address items, AfterFullAddress is updated to reflect any/all changes made. Once the user is done with the current record, I want to compare BeforeFullAddress and AfterFullAddress. If they are different, I would then send an email notification to individual that need to know about the address change.
I have all of the code built to handle the changes and the email process. Where I'm drawing a blank is determining when to trigger the before/after check and kick off the email message if necessary. What I want to do is before the user leaves the current record (next record, previous record, any record move operation), I want to do the before/after comparison, send the email if necessary, then go to the next desired record. I can't seem to find an appropriate event to do this.
Can someone point me in a good direction on this?
Kind regards,
Ken