Subform Select record

  • Thread starter Thread starter Rpettis31
  • Start date Start date
R

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.
 
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.
 
Back
Top