<div>
the DoCmd.GoToRecord , , acFirst<br />
will take you back to the first record
</div>


the DoCmd.GoToRecord , , acFirst
will take you back to the first record

<div>
once you go to the new record...are you trying to cancel IF they have already entered something into the new record?
</div>


once you go to the new record...are you trying to cancel IF they have already entered something into the new record?

<div>
you can also close the form with <br />
<br />
Private Sub cmdCancel_Click()<br />
&nbsp; &nbsp; &nbsp;If Me.Dirty Then Me.Undo<br />
&nbsp; &nbsp; &nbsp;DoCmd.Close acForm, Me.Name<br />
End Sub<br />
&nbsp;
</div>


you can also close the form with

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

<div>
Worked great. &nbsp;Thanks!
</div>


<div>
<div class="content wysiwyg-content">
Is there an AccessCommand Button to cancel an Add New Record?
</div>
</div>


Is there an AccessCommand Button to cancel an Add New Record?

AccessCommand Button to cancel an Add New Record

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.