<div>
Excellent! &nbsp;This is exactly what I needed and it worked great. &nbsp;Thank you!
</div>


Excellent!  This is exactly what I needed and it worked great.  Thank you!

<div>
<div class="content wysiwyg-content">
I have a form, called FormA, with subforms: SubFormB1 and SubFormB2. &nbsp;Here is what I would like to do:<br />
<br />
I would like to have two buttons, ButtonB1 and ButtonB2 on the FormA. &nbsp;When pressed, they would open the respective Subforms. &nbsp;So, when I push ButtonB1, SubformB1 would open.<br />
<br />
The only catch is: these buttons reside on FormA always. &nbsp;The subforms open on FormA. &nbsp;So the buttons would open and hide the other subform. &nbsp;<br />
<br />
To possible give a better visual, I imagine this to be (somewhat) like a webpage (FormA) with navigation links along the side (ButtonB1 and ButtonB2) that open contens in a frame (SubFormB1 and SubFormB2) without changing the overall page itself (FormA)<br />
<br />
Any help is greatly greatly appreciated.
</div>
</div>


I have a form, called FormA, with subforms: SubFormB1 and SubFormB2.  Here is what I would like to do:

I would like to have two buttons, ButtonB1 and ButtonB2 on the FormA.  When pressed, they would open the respective Subforms.  So, when I push ButtonB1, SubformB1 would open.

The only catch is: these buttons reside on FormA always.  The subforms open on FormA.  So the buttons would open and hide the other subform.  

To possible give a better visual, I imagine this to be (somewhat) like a webpage (FormA) with navigation links along the side (ButtonB1 and ButtonB2) that open contens in a frame (SubFormB1 and SubFormB2) without changing the overall page itself (FormA)

Any help is greatly greatly appreciated.

Using Command Buttons to show/hide subforms on a Form

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.