Too Many Forms

  • Thread starter Thread starter DS
  • Start date Start date
D

DS

Is there a way to use the same form over again. I've benn making a new
pop-up form for every Main form I have....the problem is whenever the
Pop-Up comes up the Main form goes invisible and when the Pop-Up closes
the Main form reappears. Can I use the Dim Statement for this so that I
can use the same Pop-Up form over and over again? How would it work?
Thanks
DS
 
To answer your first question: yes, there is. But you'd need to post more
detail for anyone to figure out what you're after. Pop-up form in what two
situations?
 
Is the design of your pop-up forms identical? If it is, then you should be
able to use the same pop-up form with different main forms. Unless you need
to have multiple copies of the pop-up open at the same time, you should just
be able to use DoCmd.OpenForm to open it... from whichever main form you
happen to be on.

Larry Linson
Microsoft Access MVP
 
Larry said:
Is the design of your pop-up forms identical? If it is, then you should be
able to use the same pop-up form with different main forms. Unless you need
to have multiple copies of the pop-up open at the same time, you should just
be able to use DoCmd.OpenForm to open it... from whichever main form you
happen to be on.

Larry Linson
Microsoft Access MVP
Click to expand...
I know I can use it over and over agaib to open it but the problem is
closing it. When I hit OK I have to say that the main form becomes
visable again, everytime though the main form will be different, can I
use the dim statement for this?
Thanks
DS
 
Can you use the OpenArgs to pass the pop-up form the name of the "calling"
form? Then you could use that form name to specify which form you want to
make visible, open, etc when you close the pop-up.
 
John said:
Can you use the OpenArgs to pass the pop-up form the name of the "calling"
form? Then you could use that form name to specify which form you want to
make visible, open, etc when you close the pop-up.





Sounds good, but how would I do This?
Click to expand...
Thanks
DS
 
Are you calling the form through code?
Me.Name would get the name of the form if you were calling from a button on
a form.

DoCmd.OpenForm "PopUpForm", , , , , , Me.Name

Alternatively
DoCmd.OpenForm "PopUpForm", , , , , , "MyWondrousForm"

In the close event of the Popup Form

DoCmd.OpenForm Me.OpenArgs
or
Forms(Me.OpenArgs).Visible = True
 
John said:
Are you calling the form through code?
Me.Name would get the name of the form if you were calling from a button on
a form.

DoCmd.OpenForm "PopUpForm", , , , , , Me.Name

Alternatively
DoCmd.OpenForm "PopUpForm", , , , , , "MyWondrousForm"

In the close event of the Popup Form

DoCmd.OpenForm Me.OpenArgs
or
Forms(Me.OpenArgs).Visible = True
Click to expand...
Thanks, I'll give it a try.
DS
 
Back
Top