Cancelling a New Record Entry

S

Steph

I need a button ("Cancel") on my AddInsertionOrder form
that:

a) Undos any information that was entered (if any)
b) Closes the form
 
A

Allen Browne

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

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

Access Automatically Send a notification email once a record is added 0
Combo Box Question 2
Cancel form entry 3
Can't access memory stick 6
Basing one data entry form on a previous record 6
Run-time error '3061': Too few parameters. Expected 1. 6
Excel VBA - Problem with Closing Print Preview 0
Data disappears 2

Top