I don't want to save the record!!!

[Guest_imported]

I don't want access to save the record when i close the form. Is that possible? How can i do it?<br>thx, Martin

 

[WP]

Sure,<br><br>To see if the record has changed you can look at the form's dirty property and if it has changed then apply corrective action.<br><br>so, on the close button on click event:<br><br>If Me.Dirty then Sendkeys &quot;{ESC}{ESC}&quot;<br><br><br>WP <p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a><br>

 

[Guest_imported]

Ok, but i can't close the form.<br>I tried docmd.close but there is just a beep!

 

[WP]

Marty,<br><br>Copy the form and table to a new db.&nbsp;&nbsp;Zip it and send it to me at:<br><br><A HREF="mailto:william.paton@ubsw.com">william.paton@ubsw.com</A><br><br>WP <p>Bill Paton<br><a href=mailto:wpaton@neptune400.co.uk>wpaton@neptune400.co.uk</a><br><a href=

http://www.neptune400.co.uk>www.neptune400.co.uk</a><br>

 

[rhicks]

Use the form's Before Update event to undo the entries.<br><br>Private Sub Form_BeforeUpdate(Cancel As Integer)<br>Me.Undo<br>End Sub<br><br>HTH<br>RDH<br><br> <p>Ricky Hicks<br><a href=mailto: rdhicks@mindspring.com> rdhicks@mindspring.com</a><br><a href= > </a><br>

 

[TLefkowich]

Hello. Was reading this problem and have question: can you use this code under your &quot;cancel&quot; button?

Private Sub Form_BeforeUpdate(Cancel As Integer)
Me.Undo
End Sub


Tracy