Hide a Form

[JohnPapa]

I need to open Form frmA and then Form frmB, the latter uses data from Form frmA.

DoCmd.OpenForm "frmA", , , , , acHidden
DoCmd.OpenForm "frmB"

This works, only the first time I get a glimse of frmA before it disappears. Is there a way to not show frmA, even for a few milliseconds.

Thanks,
John

 

[BigHappyDaddy]

Try setting the Visible property of frmA to FASLE.

 

[JohnPapa]

At which point do I set the Visible property to False. On Open does not work.

 

[BigHappyDaddy]

I went back and looked how I accomplished a very similiar issue and I have the same DoCmd statement that you have to open my hidden form. I don't get screen flicker of the form.

Is there anything in the Open or Load events of frmA that could be changing to property? Totally guessing here. Sorry.

 

[JohnPapa]

There is substantial code on the OnOpen of frmA.

I guess the general question is whether a form can open in the background without showing at all.

 

[nanscombe]

DoCmd.Minimize & DoEvents as the first commands in Form_Open() of frmA?

 

[JohnPapa]

Nigel,

The problem has been solved, in a slightly different manner.

The first statement in frmA was "Docmd.Maximize". I initially changed it, per your suggestion to "Docmd.Minimize". That caused other problems due to the fact that frmA contains subforms.

The problem was solved when I commented out "Docmd.Maximize"

Thanks,
John

 

[nanscombe]

I was wrong ... but at least I pointed you in the direction of the solution.

 

[JohnPapa]

Nigel, at the end of the day the problem was solved and I thank you for your help, without which, the problem may not have been solved.
John

 

[nanscombe]

That's Ok. I was just being a bit facetious.