Form/SubForm open event question

[David]

I have a form with a tabbed control. One tab contains a subform and another tabbed control within the subform
When I open the main form it is triggering the open event of the subform
Is this correct or do I have something screwed up
Is there any way to prevent this happening until the appropriate tab is pressed?

 

[Allen Browne]

Typically, the subform's Open event fires before the main form's.

You may need to use error handling to trap and ignore the first error.

If it is really important to get the order of events reversed, and the
LinkMasterFields and LinkChildFields are very simple, you could save the
main form with nothing in the subform control, and then assign the
SourceObject property later.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.

Reply to group, rather than allenbrowne at mvps dot org.

I have a form with a tabbed control. One tab contains a subform and

another tabbed control within the subform.

When I open the main form it is triggering the open event of the subform.
Is this correct or do I have something screwed up?
Is there any way to prevent this happening until the appropriate tab is

pressed?