How to open a form__

[cd]

Just a guess, but have you considered using

DoCmd.OpenForm "frmName",,,acViewHidden

(this may not have the correct number of commas and
syntax, but as you input a comma, the prompts will let you
know when "Hidden" is an option)

This will open the form but not show it. The only thing
I'm not sure of is how to make it visible other than using

DoCmd.OpenForm "frmName"

and I'm not sure if that will force it to reload
everything again or simply make it visible. There may be
a way to directly change the form from Hidden to Visible;
however, I am not aware of that solution.

Good Luck!