Subform Select record

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.
 
N

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Select row in a datasheet subform 2
select record based on record selected in the child form 4
Set Focus to add new record on subform 5
Do...Until Loop Code 2
Goto Specific Record In Subform 7
Button to delete record on datasheet subform 5
showing a subform based on the main form 5
Open Form from Datasheet to a Specific Record 3

Top