Microsoft KB Archive/210600

= HOW TO: Use a Button to Hide and Display a Subform in Access =

Article ID: 210600

Article Last Modified on 10/11/2006

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q210600



Novice: Requires knowledge of the user interface on single-user computers.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

IN THIS TASK
SUMMARY
 * Using a Macro
 * Using a User-Defined Function



SUMMARY
You can hide and display a subform by using a command button or toggle button. This article shows you how to create either a macro or a sample user-defined function that uses a command button or toggle button to hide and display the Quarterly Orders subform on the Quarterly Orders form in the sample database Northwind.mdb.

NOTE: This article explains a technique demonstrated in the sample file, FrmSmp00.mdb. For information about how to obtain this sample file, please see the following article in the Microsoft Knowledge Base:

233324 ACC2000: Microsoft Access 2000 Sample Forms Available in Download Center

Microsoft provides programming examples for illustration only, without warranty either expressed or implied. This includes, but is not limited to, the implied warranties of merchantability or fitness for a particular purpose. This article assumes that you are familiar with the programming language that is being demonstrated and with the tools that are used to create and to debug procedures. Microsoft support engineers can help explain the functionality of a particular procedure, but they will not modify these examples to provide added functionality or construct procedures to meet your specific requirements. The following steps demonstrate how to use a command button to hide and display a form.

back to the top

Using a Macro
 Open the sample database Northwind.mdb.  Create the following new macro, and then save it as Toggle Macro:   Macro Name      Action Toggle Macro   SetValue

Toggle Macro Actions --  SetValue Item: [Quarterly Orders Subform].Visible Expression: Not [Quarterly Orders Subform].Visible  Open the Quarterly Orders form in Design view. Set the AllowEdits property of the form to Yes. Add a command button to the detail section on the form.  Set the following properties for the command button: <pre class="fixed_text">  Caption: Toggle Subform OnClick: Toggle Macro </li> View the form in Form view. Note that when you click the command button, the Quarterly Orders subform is hidden or displayed.</li></ol>

back to the top

Using a User-Defined Function
<ol> Open the sample database Northwind.mdb.</li> Open the Quarterly Orders form in Design view.</li> Set the AllowEdits property of the form to Yes.</li> Add a command button or toggle button to any open area on the form.</li>  Set the following properties for the command button: <pre class="fixed_text">  Name: cmdToggle Caption: Toggle Subform OnClick: [Event Procedure] Set the OnClick property of the command button to the following event procedure: Sub cmdToggle_Click Me![Quarterly Orders Subform].Visible = _ Not Me![Quarterly Orders Subform].Visible End Sub </li> View the form in Form view. Note that when you click the toggle button, the Quarterly Orders subform is alternatively hidden and displayed.</li></ol>

back to the top

Additional query words: togglebutton show make visible or invisible

Keywords: kbhowto kbhowtomaster kbprogramming kbusage KB210600

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.