• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1846
  • 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

Featured Post

[Webinar] Improve your customer journey

A positive customer journey is important in attracting and retaining business. To improve this experience, you can use Google Maps APIs to increase checkout conversions, boost user engagement, and optimize order fulfillment. Learn how in this webinar presented by Dito.

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