<div>
Fantastic. That works great. Thanks.
</div>


<div>
You are welcome!<br />
<br />
/gustav
</div>


<div>
<div class="content wysiwyg-content">
When a user double-clicks on a record in a subform, &nbsp;I want a split form to open showing all the invoice records for that project but the top part showing the particular invoice that they clicked on. At the moment I have:<br />
<br />
DoCmd.OpenForm &quot;frmInvoice&quot;, , , &quot;[ProjectID]=&quot; &amp;&nbsp;Me.ProjectID<br />
<br />
and this opens showing all the invoices for that project but the particular invoice they want is not showing in the top part. I want to reference the top part as something like <br />
<br />
&quot;[InvoiceID]=&quot; &amp;&nbsp;me.InvoiceID<br />
<br />
Thanks
</div>
</div>


When a user double-clicks on a record in a subform,  I want a split form to open showing all the invoice records for that project but the top part showing the particular invoice that they clicked on. At the moment I have:

DoCmd.OpenForm "frmInvoice", , , "[ProjectID]=" & Me.ProjectID

and this opens showing all the invoices for that project but the particular invoice they want is not showing in the top part. I want to reference the top part as something like 

"[InvoiceID]=" & me.InvoiceID

Thanks

What is the vba to open a split form to a certain record?

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.

Microsoft Development

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.