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.