What is the vba to open a split form to a certain record?
Posted on 2013-06-17
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