<div>
1. set the Data Entry property to Yes<br />
2. or open the form in Dataentry mode <br />
&nbsp; &nbsp; docmd.OpenForm &quot;formx&quot;,,,,acFormAdd
</div>


1. set the Data Entry property to Yes
2. or open the form in Dataentry mode
    docmd.OpenForm "formx",,,,acFormAdd

<div>
And the form is opened with:<br />
<br />
DoCmd.OpenForm &quot;frmFormName&quot;, acFormDS, , , acFormEdit, acWindowNormal<br />
<br />
Because I do want the other records to display.
</div>


And the form is opened with:

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

Because I do want the other records to display.

<div>
<div class="content wysiwyg-content">
I have a form opening in datasheet view. &nbsp;But when it opens I want the focus to be on a new record. &nbsp;How can this be done?
</div>
</div>


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?

How open datasheet form to new record

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.