use a value in a text control to goto a record on a nested subform

  • Thread starter Thread starter efandango
  • Start date Start date
E

efandango

I want to be able to double-click a text control called [Joiner_Title_ID] on
my 'departure' form and use the value in that control to find a matching
record on a 2nd tier nested subform.


My Mainform is called: 'frm_Runs'
My 1st 'target' Subform is called: 'frm_Street_Joiner_Main'
My nested target Subform2 is called: 'frm_Street_Joiner_Sub'
My nested target conrol on Subform2 is called: [Joiner_Title_ID]

My departure form is called: 'frm_Street_Joiner_Matches'
My departure conrol is called: [Joiner_Title_ID]

I know how to set an event, but am not sure about the required code/syntax...
 
I don't think you need any codes Are the forms linked child master. If so
use a goto on the main form and set focus to the 2nd sub then the control
 
No, the departure form is seperate from the nested subform. The departure
form has the control that I want to click and it also has the record number
reference for the Destination form control that I want to set the focus to.

Wayne-I-M said:
I don't think you need any codes Are the forms linked child master. If so
use a goto on the main form and set focus to the 2nd sub then the control


--
Wayne
Manchester, England.



efandango said:
I want to be able to double-click a text control called [Joiner_Title_ID] on
my 'departure' form and use the value in that control to find a matching
record on a 2nd tier nested subform.


My Mainform is called: 'frm_Runs'
My 1st 'target' Subform is called: 'frm_Street_Joiner_Main'
My nested target Subform2 is called: 'frm_Street_Joiner_Sub'
My nested target conrol on Subform2 is called: [Joiner_Title_ID]

My departure form is called: 'frm_Street_Joiner_Matches'
My departure conrol is called: [Joiner_Title_ID]

I know how to set an event, but am not sure about the required code/syntax...
Click to expand...
Click to expand...
 
Back
Top