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

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

 

[Wayne-I-M]

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

 

[efandango]

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.

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.

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