Solved

How open datasheet form to new record

Posted on 2014-12-22
3
236 Views
Last Modified: 2014-12-22
I have a form opening in datasheet view.  But when it opens I want the focus to be on a new record.  How can this be done?
0
Comment
Question by:SteveL13
3 Comments
 
LVL 119

Expert Comment

by:Rey Obrero
Comment Utility
1. set the Data Entry property to Yes
2. or open the form in Dataentry mode
    docmd.OpenForm "formx",,,,acFormAdd
0
 
LVL 18

Accepted Solution

by:
SimonAdept earned 500 total points
Comment Utility
One way is to put this into the form.Open event

DoCmd.GoToRecord , , acNewRec
0
 

Author Comment

by:SteveL13
Comment Utility
And the form is opened with:

DoCmd.OpenForm "frmFormName", acFormDS, , , acFormEdit, acWindowNormal

Because I do want the other records to display.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In Debugging – Part 1, you learned the basics of the debugging process. You learned how to avoid bugs, as well as how to utilize the Immediate window in the debugging process. This article takes things to the next level by showing you how you can us…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
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.
In Microsoft Access, learn how to use Dlookup and other domain aggregate functions and one method of specifying a string value within a string. Specify the first argument, which is the expression to be returned: Specify the second argument, which …

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

12 Experts available now in Live!

Get 1:1 Help Now