<div>
Thanks for the tip Rory. &nbsp;Always looking for best practices.<br />
<br />
The trick was, someone could load the form once, Cancel, then load it again with a different location (form list files in a folder designated on the main form).<br />
<br />
Thus I need to Unload the formASD before I Show it, just in case it's not the first time.<br />
<br />
Cheers,<br />
WC
</div>


Thanks for the tip Rory.  Always looking for best practices.

The trick was, someone could load the form once, Cancel, then load it again with a different location (form list files in a folder designated on the main form).

Thus I need to Unload the formASD before I Show it, just in case it's not the first time.

Cheers,
WC

<div>
<div class="content wysiwyg-content">
I have a form which is initialized and shown by code from a button on another form. &nbsp;When the &quot;embedded&quot; form is closed, the original form is also closed and unloaded. &nbsp;If I just Hide the &quot;embedded&quot; form, there is no issue.<br />
<br />
Now, to get around this, in the main form I am using<br />
<br />
Unload formASD<br />
formASD.Show<br />
<br />
and in the formASD I'm just using<br />
<br />
Me.Hide<br />
<br />
That solution is fine. &nbsp;I guess I am just curious if the behavior I am experiencing when using Unload Me on the embedded form is normal or not?<br />
<br />
WC
</div>
</div>


I have a form which is initialized and shown by code from a button on another form.  When the "embedded" form is closed, the original form is also closed and unloaded.  If I just Hide the "embedded" form, there is no issue.

Now, to get around this, in the main form I am using

Unload formASD
formASD.Show

and in the formASD I'm just using

Me.Hide

That solution is fine.  I guess I am just curious if the behavior I am experiencing when using Unload Me on the embedded form is normal or not?

WC

Unload Me is causing an error which closes all forms

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.