Solved

How do I get a form to start with a new record everytime you open it?

Posted on 2011-03-01
3
326 Views
Last Modified: 2012-06-27
I have user when they are in a form they have to manually go to a new record. Where do I go in form properties to change this so that the form starts with a new record everytime its opened?
0
Comment
Question by:gigifarrow
3 Comments
 
LVL 10

Expert Comment

by:VTKegan
Comment Utility
Set the Data Entry property to True.
0
 
LVL 7

Accepted Solution

by:
RemRemRem earned 125 total points
Comment Utility
VTKegan's idea will work but only if you ONLY want new records to be included.

If you put:

    DoCmd.GoToRecord , , acNewRec

in your OnLoad event for the form, it will have all the records unfiltered (assuming no other filters on the form) but will start you at a new record upon loading the form each time.

-Rachel
0
 

Author Comment

by:gigifarrow
Comment Utility
straight to the point
0

Featured Post

Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

Join & Write a Comment

It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
QuickBooks® has a great invoice interface that we were happy with for a while but that changed in 2001 through no fault of Intuit®. Our industry's unit names are dictated by RUS: the Rural Utilities Services division of USDA. Contracts contain un…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

763 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

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now