cancel update of record

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chegu Tom - 30 Jan 2008 19:50 GMT

I want to put a button on my form with code that will tell access to close
the form and not update the current record.

Assuming the user has entered information on the form and then reailzes he
doewnt want that info in the database

Thanks

Reply to this Message

John W. Vinson - 30 Jan 2008 21:38 GMT

>I want to put a button on my form with code that will tell access to close
>the form and not update the current record.
[quoted text clipped - 3 lines]
>
>Thanks

Use the Code Builder to put into the [Event Procedure] of the command button's
click event:

Private Sub cmdQuit_Click()
Me.Undo ' erase all changes to the current record
DoCmd.Close acDataForm, Me.Name ' close the form
End Sub

John W. Vinson [MVP]

Reply to this Message

Chegu Tom - 01 Feb 2008 20:44 GMT

me.Undo

me.DUH or me.DOH (Homer Simpson style)

Thanks. For some reason I could not remember that.

Tom

>>I want to put a button on my form with code that will tell access to close
>>the form and not update the current record.
[quoted text clipped - 14 lines]
>
> John W. Vinson [MVP]

Reply to this Message