cancel button for form

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

How do you program a cancel button so that the form does not file the
information in the table?
 
Set the button's cancel property to True and then place the following code in
the button's _Click procedure:

Private Sub cmdCancel_Click()
If Me.Dirty Then
Me.Undo
End If
DoCmd.Close acForm, Me.Name

End Sub
 
First, you have a Cancel button preprogrammed for you. The Esc key does this
job. Educate the user that pressing Esc once undoes the current control and
pressing Esc a second time undoes the current record.

That said, the code you need behind a button is

Me.Undo
 
thanks, jason & wayne

Wayne Morgan said:
First, you have a Cancel button preprogrammed for you. The Esc key does this
job. Educate the user that pressing Esc once undoes the current control and
pressing Esc a second time undoes the current record.

That said, the code you need behind a button is

Me.Undo
Click to expand...
 
You must log in or register to reply here.

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

Cancel/BeforeUpdate Event Procedure 1
How to prevent form from closing 2
Data Entry Form 3
Don't add record 1
itemsend 0
Modify Message Box Cancel Button 6
Cancel form changes 6
Conditional Text on a Command Button 6

Back
Top