Open a Form as a SubForm
<p>On a GUI based on forms, I try to open and close some forms in order to do calculations.</p>

<p>I want to do it only with Access macros (for easier maintenance by non-technical personnel).</p>

<p>The problem is not to open and close the forms, I've found a way to do this with: </p>

<pre><code>Close Window
ObjectType
ObjectName
Save: With Confirmation

OpenForm
Form Name: destinationForm
Display
Filter Name
Where Condition
Data Mode
Window Mode: Standard
</code></pre>

<p>But when the forms are part of bigger form (that I called Layout for explicit reasons), this macro close the main form  and open destinationForm as a new one.</p>

<p>I know this behaviour is perfectly <strong>normal</strong>, but I haven't found marcos closing <strong>subform</strong> and opening other ones yet, or, even easier, changing Object Source of the subform object of my Layout form.</p>