• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2002
  • Last Modified:

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?
0
Coaster_brook_trout
Asked:
Coaster_brook_trout
  • 2
  • 2
1 Solution
 
Rey Obrero (Capricorn1)Commented:
place this codes in the click event of the button that you added

docmd.gotoRecord,,acNewRec
0
 
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
0
 
Rey Obrero (Capricorn1)Commented:
<part but it doesn't work. > what do you mean? how it does not work?
0
 
Coaster_brook_troutAuthor Commented:
Sorry it worked for some reason I had to close my database and reopen - thanks so much!
0
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.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now