Cross Calculations within sub-forms with "On Current" event

[krag]

I have a parent form with 5 different sub-forms. Only 2 of the sub-forms have parent-child link. Others have independent calculation formula for these 2 sub-forms. One sub-form has several records and for each record calculation is done on other sub-forms. I have programmed the linking calculation through event procedure for "On Current" of the multi-record sub-form.
When the parent form is opened, I get a error message on the linking program, not finding the linked fields in other sub-form. I think it is because of sequence of timing of opening each sub-form within parent form.
Is there any way to control the sequence of opening of child forms in parent form?

[ItsMe]

It sounds as though the subform that is causing the error should not have a value in its Main/Child link properties. If you are programmatically adjusting the Subform's Recordset/Filter properties, there should not be a need for a Main/Child Link

[krag]

Hi ItsMe
I have checked it is not related to parent-child link. The error appears only when I open the form first time. If I proceed by cancelling the error and navigate through the records in the sub-form, it works fine without any errors.

[June7]

What is the exact error message?

What do you mean by 'linking calculation'?

You could leave the subform container controls SourceObject property blank and then set that property for each with code behind the main form, perhaps in the Load event.