Hide and Unhide forms

[Paul H]

Hello,



I have a main form that opens other forms. These forms in turn open other forms, etc. What happens is I end up with a pile of forms of different sizes that poke out from behind the next form that opens. I am looking for a simple way to hide and unhide these forms when they lose focus and get focus, but I am finding that neither of those events are occurring. I did switch to using the command button that calls the next form to set the current forms Visible property to False. What I can't figure out is how to set the invisible form's Visible property back to true. I want to work it out so only one form is visible at a time. I am doing it this way because I can't close the current form since the new forms depend if the previous forms. Since the previous form I want to display is still open I can't use the OnLoad event or the On Open event.

Previously the application displayed the forms in tabs which completely covered the previous form so this was not a problem. I just thought this didn't look professional and changed Document Windows property to overlapping tiles.

Hope you can help.

[Dave14867]

I would suggest using VBA to "minimize" a form when you don't want it visible, and "maximize" when you do. I don't know what you are doing and when you want to make a form visible and not visible because I don't have enough info but see if that helps.

[Paul H]

I want to hide it(turn Visible to False) when the new form pops up and unhide when that form closes. Hiding it is easy. Unhiding it (turning visible back to True) is where I'm stuck. Minimizing it would not be my choice since it would still be visible to the user.
I'm unsure how to set the original forms Visible property back to True.

[Bob Fitz]

Try:

Forms!NameOfForm.Visible = True

When you close hide the second form

[Missinglinq]

...I am looking for a simple way to hide and unhide these forms when they lose focus and get focus, but I am finding that neither of those events are occurring...

That's correct! What you need to know is that a Form cannot receive or lose Focus if it has one or more Controls that can receive Focus!

Seems odd, I know, but it is what it is! For this kind of thing you need to use the Form_Activate()/Form_Deactivate() events.

Because you cannot return Focus to a Form that is invisible, I agree with Dave about using the Minimze/Maximise commands for this.

Linq ;0)>

[Paul H]

I agree with Dave about using the Minimze/Maximise commands for this.

That seems to be work.