Hiding/Unhiding form from menu bar and by clicking a button

[Geert1969]

Hi,

I'm new to this forum.
I'm developing an Access 2003 database. In that database I have a form that starts up when the database is opened. On this startup form I have buttons to open other forms. Those other forms I also can open from a custom menu bar. This to make the database as user friendly as it is possible.
Now I want to hide the startup form whenever I open another form by either opening it from the menu bar or either by clicking on a button on the startup form.
When the other form is unloaded, the startup form needs to be unhided.
Now, I do know the code to hide/unhide the startup form by clicking on a button on that form. But not in combination when a form is opened from the menu bar.
Is this workable? And if yes, how should I do in VBA code?

Thank you very much for your help.

[pod]

although it might not be what is best for you, but you could put in the code to "hide all other forms" in each form's OnLoad event ... this way it does not matter how the form is opened

[Mihail]

My practice:

From Form_Start I wish to open Form_Localitati by clicking a button named cmdOpen_Localitati:

Private Sub cmdOpen_Localitati_Click()
    Me.Visible = False
    DoCmd.OpenForm "Localitati", , , , , , Me.Name
End Sub

Note please that I pass the name of current form in OpenArgs arguments (, , , , , , Me.Name)

The code in Form_Localitati (the second form) will be:

Option Explicit
Dim FormaApelanta 'Retain the main form's name
 
Private Sub Form_Load()
    FormaApelanta = Me.OpenArgs
    ............
End Sub
 
Private Sub Form_Close()
Dim frm As Form
    For Each frm In Application.Forms
        If frm.Name = FormaApelanta Then
            frm.Visible = True 'Make visible the main form
    Exit For
        End If
    Next frm
    ............
End Sub

[NeoPa]

I'm afraid I had to reset the Best Answer as it doesn't actually answer the question. There is nothing in there to handle making the calling form visible again on close of the called form.

Personally, I handle this situation with a class that captures closing of a form and remembers where the open was called from, but the simpler answer has been posted already by Mihail. As it's already there I won't repeat it. I may suggest that such a call (using OpenArgs) is much more clear when using named parameters, but otherwise this is an easy and well laid out solution which really ought to have been selected as Best Answer.

I'm open to posting my class-based solution if anyone's interested, but it's less straightforward than using OpenArgs frankly.

[Mihail]

Hi !
Yes NeoPa. I am interested to see your solution because I wish to learn about classes. I know what the classes can do but I don't know HOW. So, if you are so kind... Thank you !

[NeoPa]

Check out Class Module to Handle Opening Forms Hierarchically. Feel free to ask any questions on it, but not in the Insight unless it's relevant there.