Modal / PopUp Via Code???

[MHadden]

I have a form that is modal & popup. This is great, except that I have buttons on it which open other windows, well as you know this opens the window behind the Popup window.
My question: is there a way to change the modal / popup status via VBA?
If anyone has an answer I would be most grateful!!
Thanks In Advance,
Michael MHadden@knology.net
If you give someone a fish, you have given them a meal. If you teach someone to fish, you have given them MANY meals!

 

[GeekGirlau]

You can use either "Me.Popup=False" or "Me.Modal=False", but I would suggest just minimising the form before launching the other forms - DoCmd.Minimize

 

[MHadden]

Thanks a lot!
Sorry I took so long to respond, but the computer was on the fritz.
I'll try the suggestions as soon as I can
Thanks,
Michael MHadden@knology.net
If you give someone a fish, you have given them a meal. If you teach someone to fish, you have given them MANY meals!