Open a new form with a specific record

[hdesbiens]

Hi

I have a form client and on that form is a subform with a list of invoice on it.

What i want to do i when i dblclik on a record, i open the form invoice and get position on the invoice number.

Is there a way to do that?

thanks a lot

 

[rjoubert]

In the double click event, use the Docmd.OpenForm method, passing in a WHERE clause...

DoCmd.OpenForm "Invoice", acNormal, , "[InvoiceNumber]=" & myInvoiceNumber

 

[hdesbiens]

Thank you very much it works

have a nice day