[RESOLVED] Form Assistance

[Snuffles]

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.

[RobDog888]

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.

[jmcilhinney]

In your module you can use something like this:

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

[Snuffles]

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