Parameter prompts when subforms load

[jzacharias]

I have a main form with 3 subforms. When I first open the database I receive parameter prompts and if I cancel them the subforms don't load correctly. If I close and reopen the main form everything loads fine. The subforms reference a control on the main form and I'm guessing the control isn't available as the subform loads before the main form. Is there a way to delay the loading of the subforms until the control on the main form is available?

[ranman256]

Either you have a text box bound to a field that
does not exist in the query
or
is spelled wrong.

[Micron]

As you say, subform events occur first, then the main form. From a purist's point of view, it's probably better to prevent this by design, but I'd say it's not always possible. I presume you are aware that setting parameters, filters etc. will often fail on the open event and you are in fact trying to set these in a load event. You can Google "ms access subform form load order" and you will find some approaches. here's one: https://accessexperts.com/blog/2013/...re-main-forms/