Save,Cancel,Delete,Close...

[uncchcs]

I have a form with buttons where users can save,cancel,delete,create new, or close the form. What I want to do, is if the user attempts to close the form after changing data without clicking save, prompt them on close to accept or cancel changes. The same if they attempt to close with the close button. Anyone have any suggestions?

Jason

 

[archery]

At your appropriate points put the following (or better still, make it a Private function and Call it from your appropriate points (so you only have the one piece of code)):

If Me.Dirty = True then
msgbox <with your prompt>
.... do whatever code or process you want here

End If