Link to home
Start Free TrialLog in
Avatar of Coaster_brook_trout
Coaster_brook_troutFlag for United States of America

asked on

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?
ASKER CERTIFIED SOLUTION
Avatar of Rey Obrero (Capricorn1)
Rey Obrero (Capricorn1)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Coaster_brook_trout

ASKER

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
<part but it doesn't work. > what do you mean? how it does not work?
Sorry it worked for some reason I had to close my database and reopen - thanks so much!