Finding a Record from a subform

  • Thread starter Thread starter Dave
  • Start date Start date
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
 
Back
Top