<div>
Hello Bill201,<br />
<br />
Try these codes:<br />
<br />
DoCmd.GoToRecord acDataForm, &quot;form1&quot;, acNewRec<br />
Forms!form1.SetFocus<br />
Forms!form1!InvoiceNum.Set<wbr />Focus<br />
<br />
Sincerely,<br />
<br />
Ed
</div>


Hello Bill201,

Try these codes:

DoCmd.GoToRecord acDataForm, "form1", acNewRec
Forms!form1.SetFocus
Forms!form1!InvoiceNum.SetFocus

Sincerely,

Ed

<div>
thanks alot for your answer but i get an error message after the first line (it's a sub form so it's look like this :<br />
<br />
DoCmd.GoToRecord acDataForm, &quot;Forms!form1parent!form1ch<wbr />ild.Form&quot;,<wbr /> acNewRec<br />
<br />
and i get an error message like this &quot;run time error 2489 the object &quot;Forms!form1parent!form1ch<wbr />ild.Form&quot; isn't open. But the form is actually open, so what is going on there?
</div>


thanks alot for your answer but i get an error message after the first line (it's a sub form so it's look like this :

DoCmd.GoToRecord acDataForm, "Forms!form1parent!form1child.Form", acNewRec

and i get an error message like this "run time error 2489 the object "Forms!form1parent!form1child.Form" isn't open. But the form is actually open, so what is going on there?

<div>
<div class="content wysiwyg-content">
hi<br />
<br />
i can two forms open for expamle the names are form1 and form2<br />
<br />
and i wan't when i press on some button in form2 it's will set the focus on form1 in a new record by the field form1!Id<br />
<br />
something like this <br />
<br />
&nbsp;<br />
&nbsp; &nbsp; &nbsp; &nbsp; DoCmd.GoToRecord (on form1) , , acNewRec<br />
&nbsp; &nbsp; &nbsp; &nbsp; DoCmd.GoToControl (&quot;form1!InvoiceNum&quot;)
</div>
</div>


hi

i can two forms open for expamle the names are form1 and form2

and i wan't when i press on some button in form2 it's will set the focus on form1 in a new record by the field form1!Id

something like this 

 
        DoCmd.GoToRecord (on form1) , , acNewRec
        DoCmd.GoToControl ("form1!InvoiceNum")

add new record on a other open form with vba on microsoft access 2013

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.

Microsoft Access

Visual Basic is Microsoft’s event-driven programming language and integrated development environment (IDE) for its Component Object Model (COM) programming model. It is relatively easy to learn and use because of its graphical development features and BASIC heritage. It has been replaced with VB.NET, and is very similar to VBA (Visual Basic for Applications), the programming language for the Microsoft Office product line.

Visual Basic Classic

Most development for the Microsoft platform is done utilizing the technologies supported by the.NET framework. Other development is done using Visual Basic for Applications (VBA) for programs like Access, Excel, Word and Outlook, with PowerShell for scripting, or with SQL for large databases.