Cancel a Form's DB Action

D

dave h

Hi,

I have a case where I don't want to save a record to a table if the user
clicks the X in the upper right corner of the form.
In the before update event, I set cancel=true and this stops the save action
just as I wanted - except I still get this message

"You can't save this record at this time" .....click Yes to close DB object

I don't want this message. "docmd.setwarnings false" does not suppress the
message and I can't seem to trap an error anywhere.

How can I prevent this message from being displayed?

Thanks - Dave H.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top