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
Solved

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

Posted on 2011-03-01
3
352 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
ID: 35008839
Set the Data Entry property to True.
0
 
LVL 7

Accepted Solution

by:
RemRemRem earned 125 total points
ID: 35009143
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
ID: 35010015
straight to the point
0

Featured Post

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

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

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
In Microsoft Access, learn how to “cascade” or have the displayed data of one combo control depend upon what’s entered in another. Base the dependent combo on a query for its row source: Add a reference to the first combo on the form as criteria i…
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.

839 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