Prompt for Save on Form Close. Keep Open if Yes and Close if No.

[sgupta76]

I have an unbound form with a save button. When a user clicks on the X button to close the form, I want to pop up a message box asking if they want to save the data or not. If yes, then I want the form to remain open so they can then click on the Save button and save data.
If they select No, then the form closes.

How do I prevent the form from closing when the user selects 'Yes'?

thanks.

 

[timekeepr9]

Why not just have it save automatically if they click yes? Just copy paste what the save command does into the click yes code.

 

[sgupta76]

Thanks timekeeper. I found another thread that addressed my issue where I can change the controlbox property to No and then create a save button and put my code there.