Close Form Without Saving Record

A

Anne

This should be easy, but I'm having a big old block (it's
too nice outside today).

Tried: docmd.close,,acSaveNo, but of course this closes
the form without saving design changes.

Thanks in advance for your assistance to the "brain-
already-on-vacation".
 
A

Allen Browne

Undo the form if it is dirty:

If Me.Dirty Then
Me.Undo
End If
DoCmd.Close acForm, Me.Name
 

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

Similar Threads

Closing form without saving changes 4
Close form without saving 13
Close button without Saving changes 4
How do I close a form without saving the record 3
datasheet view 2007 without saving column layout changes 2
Form to close itself after double-click event in a control 1
Closing a Bound Form without Saving to the underlying table? 3
Close Form/Subform without Saving Changes 1

Top