Solved

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

Posted on 2011-03-01
3
359 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
[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
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Google drive Permission Error 43 49
Union & Crosstab qrys 101! 6 58
Convert VBA UDF to SQl SERVER UDF 4 52
Access Runtime Error '3070' 5 10
Introduction The Visual Basic for Applications (VBA) language is at the heart of every application that you write. It is your key to taking Access beyond the world of wizards into a world where anything is possible. This article introduces you to…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
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…
Familiarize people with the process of utilizing SQL Server functions 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 Microsoft Ac…

730 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