Finding a Record from a subform

D

Dave

I have 2 subforms on a Tab Page on a main form. (frmParts)

One sub is a small "continuous" form showing just a few fields from each
record, and with each record having an key [IDNo]. (frmPartsDetail)
The other form is a "single" form (based on the same query as the
continuous
sub), but it displays ALL the fields of the record. (frmPartsReceive)

I'd would like the user to be able to locate a record for editing (on the
single form), by dbl-clicking on the IDNo on the continuous subform.
The code would all be run from the continuous form.

Seems as though I'd need to:
Capture the IDNo at the moment of DblClick
Move the cursor (or focus) from the continuous sub to the single sub
Move to the IDNO field on the single form
Do a DoCmd.Find Record.

Tried all kinds of GoToControl, SetFocus, and addressing schemes, but
can't seem to get it to work.
Any help would be appreciated.
Thank you,
Dave
 

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

Go to a Specific Record on a Subform 3
Using Check Boxes to select items in an Access subform. 0
Set Focus to Record Selector? 1
Conditional marker on subform? 1
Update SQL on non-record set causes requery 3
Form with subform and record insert problems 2
How to pass data to a subform from a continuous form? 3
Set focus in a specific record within a subform 1

Top