Solved

Add new record button in Access 2007

Posted on 2014-04-08
4
1,617 Views
Last Modified: 2014-04-11
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
Comment
Question by:Coaster_brook_trout
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 120

Accepted Solution

by:
Rey Obrero (Capricorn1) earned 500 total points
ID: 39986472
place this codes in the click event of the button that you added

docmd.gotoRecord,,acNewRec
0
 

Author Comment

by:Coaster_brook_trout
ID: 39986489
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
 
LVL 120

Expert Comment

by:Rey Obrero (Capricorn1)
ID: 39986548
<part but it doesn't work. > what do you mean? how it does not work?
0
 

Author Comment

by:Coaster_brook_trout
ID: 39994863
Sorry it worked for some reason I had to close my database and reopen - thanks so much!
0

Featured Post

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Preparing an email is something we should all take special care with – especially when the email is for somebody you may not know very well. The pressures of everyday working life stacked with a hectic office environment can make this a real challen…
In Part II of this series, I will discuss how to identify all open instances of Excel and enumerate the workbooks, spreadsheets, and named ranges within each of those instances.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question