Originally Posted by
timfoster
...I have an unbound form that contains 4 sub forms...
...Can somebody explain exactly what goes on under the hood of DoCmd.OpenForm...
It's not actually the OpenForm command. I think what you're missing here is the fact that when you have a Main Form with Subforms, and you start that Form (regardless of how you start it) all of the Subforms load before the Main Form loads. In other words, as strange as it sounds, all four of your Subforms are loaded before the Main Form's OnLoad event fires, which is where you're experiencing your logjam.
The workaround to this kind of thing is usually leaving the RecordSource of the Subforms blank until after the Main Form has Opened/Loaded, then assigning their RecordSources.
Linq ;0)>
The problem with making anything foolproof...is that fools are so darn ingenious!
All posts/responses based on Access 2003/2007