go record on a subform with value from, and while on an unbound subform also on the main form

[markjkubicki]

on a (main) form I have an unbound subform


I'd like to set to focus on a different (and bound) subform (on that same main form) with value from that I've gotten from the unbound subform, and while still on that unbound subform

this is to aligned the record focus on the bound subform with info on the unbound subform
(the bound subform is continuous, the unbound is not..)

I have this code on the unbound subform at the 'after event' of one of its controls:

    

    SrchVar = vType_initial                                                                                    'value gotten from the unbound subform
    Forms![frmSubmittal].Form![fsubSubmittal_details].SetFocus                              'main form: "frmSubmittal"; bound subform: "fsubSubmittal_details"
    Forms![frmSubmittal].Form![fsubSubmittal_details].cboType.SetFocus                 ' "cboType" is a valid type on the bound subform
    DoCmd.FindRecord SrchVar, acEntire, False, acSearchAll, False, acCurrent, True

runtime error: 2465 cant find field 'fsubSubmittal_details'

with many thanks in advance,
mark

[John_G]

Forms![frmSubmittal].Form![fsubSubmittal_details].SetFocus

That's not the correct syntax for referring to a subform. You need to include the name of the main form control that contains the subform, and you do not use the actual name of the subform. For example, if the name of the main form control (the one containing the subform) is ctlSubForm, you could use something like this:

Forms![frmSubmittal]!ctlSubform.Form.SetFocus