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

This article was previously published under Q210600
This article has been archived. It is offered "as is" and will no longer be updated.
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
You can hide and display a subform by using a command button or togglebutton. This article shows you how to create either a macro or a sampleuser-defined function that uses a command button or toggle button to hideand 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 samplefile, 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

  1. Open the sample database Northwind.mdb.
  2. 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					
  3. Open the Quarterly Orders form in Design view.
  4. Set the AllowEdits property of the form to Yes.
  5. Add a command button to the detail section on the form.
  6. Set the following properties for the command button:
       Caption: Toggle Subform   OnClick: Toggle Macro					
  7. View the form in Form view. Note that when you click the command button, the Quarterly Orders subform is hidden or displayed.
back to the top

Using a User-Defined Function

  1. Open the sample database Northwind.mdb.
  2. Open the Quarterly Orders form in Design view.
  3. Set the AllowEdits property of the form to Yes.
  4. Add a command button or toggle button to any open area on the form.
  5. Set the following properties for the command button:
       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].VisibleEnd Sub					
  6. View the form in Form view. Note that when you click the toggle button, the Quarterly Orders subform is alternatively hidden and displayed.
back to the top
togglebutton show make visible or invisible
Properties

Article ID: 210600 - Last Review: 12/05/2015 11:35:19 - Revision: 3.2

Microsoft Access 2000 Standard Edition

  • kbnosurvey kbarchive kbhowto kbhowtomaster kbprogramming kbusage KB210600
Feedback