Table NOT TO update if SendObject cancelled

[Hello World]

Hi all,



Need help with this one big time if that’s ok.

I have a form (Form1). This form will be used by HR/Personal staff to enter in how employees have responded to a particular question. Once the employee has been located on the form a combo box (Answer) is used to enter in how the employee has answered. If the employee has said anything but ‘Yes’ then an email is fired off using SendObject to their manager. The user of the form gets a chance to preview the email before pressing ‘Send’. And this is where my problem is.

If the user of the form cancels the email at the point of previewing it then they are returned to the form whereupon the form refreshes itself so it is blank and ready for the next employee (this is all good and what I want). However, the employee’s answer has already been put into the table connected to the form (Table1). What I need to know is how do I ‘remove’ the answer from the table so that in effect if the email is cancelled/not sent then their answer is removed from the table?

Thanks in advance!

[pbaldy]

IIRC, closing the email without sending throws a 2501 error, which can be trapped. If you're getting that error when you close the email, you could use an error trap to either stop the save or delete the record if already saved.