Full Version: Start Form Hiding
UtterAccess Discussion Forums > Microsoft® Access > Access Forms
essaysmith
Hi, back at Access after a 5 year hiatus, still don't know much.
I have a startup form that the user uses to select one of many input forms. I have the startup set to visible=false when you go to an input form since the startup is a popup. When the input form is closed it sets the visible=true for the startup to go back to the startup.
The trouble arises when the user opens 2 or more input forms at the same time, when one is closed it "visibles" the startup over the others. Is there a way to keep the startup hidden until ALL other forms are closed?
Hope this makes sense.
Thanks,
Shawn
dashiellx2000
What I do is hide all forms as new ones open and send the "calling" form's name via the open arguments:

DoCmd.OpenForm "frmName",,,,,,Me.Name
Me.Visible = False

Then for the close command on the "called" form:

DoCmd.OpenForm Me.OpenArgs
DoCmd.Close acForm, Me.Name


HTH.
essaysmith
Thanks,
I think I have forgotten far more than I remember when it comes to Access. That's what I get for a major career shift. I'll give that a try and let you know.
Shawn
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.