[RESOLVED] Form Assistance

My project uses 5 forms and 3 of these forms need to be accessible to other forms. I have declared these forms as Public in a Code Module and am able to successfully access the properties and controls on the form.

When the app is first loaded, none of these forms are visible. When a user requires the form they simply click on a button and the form appears. After the user is done with the task on the "accesible form" my code hides the form.

The issue that I have is if I simply hide the form the values still exist and if I close the form I'm no longer able to open.

My resolution is to call a sub that clears all the controls and variables associated with these 3 forms.

My question is if there is a better way of clearing the form, so that I can simply do form.close and when the user needs the form it can reopen.

You could just do the .Close to destroy the form and clear everything. Then when you need it again you can re-instanciate it. This kind of defeats the need for it being public but it still depends on your app.

Instead of a .Show call you could call a custom procedure to clear and show so you dont have to remember to clear the form.

In your module you can use something like this:

VB Code:

Public myForm1 As Form1
 
Public Sub ShowForm1()
    If myForm1 Is Nothing OrElse myForm1.IsDisposed Then
        myForm1 = New Form1
        myForm1.Show()
    Else
        myForm1.Activate()
    End If
End Sub

I appreciate the assistance. I have been struggling with that for the past 5 days. Now I can rest soundly

:wave: