Cancelling record save message

[marathonlady]

I have a form set up. The user can decide to cancel the add to the table that is updated. When the user gets out via the menubar on the Exit, the add is cancelled, but the following message appears, which I would like to suppress since I have a message already that lets them know they are not adding the item to the database:

You can't save this record at this time. Your database may have
encountered an error while trying to save a record. If you close this object now, the data changes you made will be lost.
Do you want to close the database object anyway?

Thanks in advance for your help.

 

[The_Doc_Man]

If you used a DoCmd.Undo on your record, it should not be trying to save anything that would trigger that message. If you used another method, I'm not so sure what would happen.

How do you arrange for "The user can decide to cancel the add to the table that is updated." to happen?

Do you allow the update but then try to undo it after it was done? I.e. commit/rollback type operation?

 

[marathonlady]

It worked, DOC_MAN!!

I put in the domenuitem undo command and I am not getting the message now. Thanks for your response!