Subform Select record

[Rpettis31]

I have a form which has a subform which contains a datasheet and I would like
to have the user on double click of a paticular record in the datasheet that
would call another form displaying the specific information about that
record. Is this something I would set the focus on and how do I obtain the
value from the item in the first column on the row selected in order to show
the specific information on the called form.

 

[NevilleT]

Use the onDoubleClick event. You can pass the primary key as a parameter to
the form you are opening. Check the OpenArg function in Help. Once you have
the openarg in the new form, use Bookmark to find the record.