[AccessD] Cancel the closing of a form

I have a form that when I close it either from a close button on the form or
from the built in close button, I want to test if the current record has
changed.  If it has changed, I want to prompt the user to either Save the
record and go ahead and close the form, not save the record and close the
form, or not save the record and not close the form via a YesNoCancel
message box.

If I use the close event of the form testing for me.dirty doesn't work
because the record is already saved.

Is there any way to do this?

Rusty Hammond
IT Dept. - B-20
CPI Qualified Plan Consultants, Inc.
(620) 793-8473 ext. 416
rusty.hammond at cpiqpc.com


**********************************************************************
WARNING: All e-mail sent to and from this address will be received,
scanned or otherwise recorded by the CPI Qualified Plan Consultants, Inc.
corporate e-mail system and is subject to archival, monitoring or review 
by, and/or disclosure to, someone other than the recipient.
**********************************************************************