Hiding and revealing forms. How?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I want to hide the current form when a user presses a command button to go to
open another form or report and I want the form to be revealed when they exit
back from the other form or report. What is a good way to do this? I tried
setting/unsetting the visible property before and after the open but that
does not work. I also tried resetting to visible in the activate event and
that does not work. I tried making the open in dialog mode, that makes it
work but my custom toolbars do not display. Is there a foolproof way to do
this? Thanks.
 
I want to hide the current form when a user presses a command button to go to
open another form or report and I want the form to be revealed when they exit
back from the other form or report. What is a good way to do this? I tried
setting/unsetting the visible property before and after the open but that
does not work. I also tried resetting to visible in the activate event and
that does not work. I tried making the open in dialog mode, that makes it
work but my custom toolbars do not display. Is there a foolproof way to do
this? Thanks.
Click to expand...

Regarding: Is there a foolproof way to do this?
I don't know of ANYTHING in life (except death) that is fool proof.

You might try setting the form's Visible property to False when you
open the other form:

Docmd.OpenForm "OtherFormName"
Me.Visible = False

Then code the other form's Close event:
forms!FirstFormName.Visible = True

The above works for me.
 
Regarding: Is there a foolproof way to do this?
I don't know of ANYTHING in life (except death) that is fool proof.

You might try setting the form's Visible property to False when you
open the other form:

Docmd.OpenForm "OtherFormName"
Me.Visible = False

Then code the other form's Close event:
forms!FirstFormName.Visible = True

The above works for me.
Click to expand...

You will have to treat reports the same way.
 
Back
Top