essaysmith
Jun 29 2007, 06:40 AM
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
Jun 29 2007, 06:44 AM
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
Jun 29 2007, 06:49 AM
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.