Add new record button in Access 2007

I created a form for data entry and want to put a button at the end that says add new record, so when you click it the screen goes blank and the user can add another record. How do I do this?
Who is Participating?

Improve company productivity with a Business Account.Sign Up

Rey Obrero (Capricorn1)Connect With a Mentor Commented:
place this codes in the click event of the button that you added

Coaster_brook_troutAuthor Commented:
Like I did this under the event procedure ... part but it doesn't work. Did I put it in the wrong place?

Private Sub Command49_Click()
DoCmd.GoToRecord , , acNewRec
End Sub
Rey Obrero (Capricorn1)Commented:
<part but it doesn't work. > what do you mean? how it does not work?
Coaster_brook_troutAuthor Commented:
Sorry it worked for some reason I had to close my database and reopen - thanks so much!
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.