Question sendobject email triggered twice on form

[optionone]

Hi,

Created a simple input form that stores the data in to the table on clicking the submit button and runs a macro 'on exit' - this macro just tidies the inputted data and fires off an email with the form data. This works fine.

Trouble is the form also has a 'close form' button and whenever data has been submitted and an email sent closing the form via this button then triggers the same sendobject email send out

I've checked everything and the macro aint listed anywhere else. The 'on exit' is specific to the button and not the form itself. Any suggestions on where else to look or maybe some work around??

Thanks

 

[boblarson]

If you are sending in the On Exit, then you should set a boolean flag to check to see if it has already been done and, if so, don't run it again.

Are you using macros or VBA code?

 

[optionone]

macros - how do i set this boolean?