Triggering a macro to occur when a form window is closed

[Turbojohn]

Hi,

I am wondering whether it is possible to trigger the run of a macro when a form window is closed using the close button in the top right of a standard window?

If not, then is it possible to display a form in a window without the minimize, restore and close buttons?

I am currently using a setup whereby I have a button to close a form, and when clicked a macro is executed. However, the user could just as easily close the form using the close button of the window and the updates would not be performed.

Thanks in advance
Turbojohn

 

[Rich]

Use the UnloadEvent of the form

 

[Turbojohn]

Legend!

Cheers Rich, I used the On Close event and it worked fine!

Thanks Again
Turbojohn