onClose Event

[Richard]

Hi

I tried to undo changes with the onclose event of a form, but it doesn't
seem to work. How do I undo the changes.

Thanks in advance
Richard

 

[Todd Shillam]

Richard,

You can't--the OnClose event is too late to try and undo things. Try using
the form's BeforeUpdate event--this is a good place to prevent or stop
things just before closing or saving record details.

Best regards,

Todd

 

[Richard]

Thanks Todd

I was thinking of a way to undo changes when the user uses the close button
instead of the command buttons.

Richard

 

[Steve Schapel]

Richard,

Todd's point still holds. If new data has been entered, the Before
Update event of the form will be triggered no matter how the form is closed.