ACC2000: How to Use the Parent Property of a Subform

Article translations Article translations
Article ID: 209539 - View products that this article applies to.
This article was previously published under Q209539
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).

Expand all | Collapse all

SUMMARY

This article describes how to use a subform's Parent property to return the name of its parent form.

MORE INFORMATION

The Parent property of a control refers to the control's Parent object. In the example below, we use the Parent property of a subform to determine the name of the main form.

The correct syntax for the Parent property in macro actions called from a subform is:
Forms![Main Form Name]![Subform ControlName].Form.Parent.Name
This expression can be simplified when we consider that the Form property is the default property for the subform control. The simplified form of the above expression then becomes:
Parent.Name
The following example demonstrates how to use the Parent property in a macro:
  1. Start Microsoft Access and open the sample database Northwind.mdb.
  2. Create and save the following macro:
    Macro: Get Parent Name
    ---------------------------------------------------------------
    Action: MsgBox
    Message: ="Parent: " & Forms.Orders![Orders Subform].Form.Parent.Name
    Title: Parent Form Name
    NOTE: You can substitute the simplified expression "Parent.Name" for the full expression used in this example.

  3. Open the Orders Subform form in Design view. Add the Get Parent Name macro to the OnDblClick event of the ProductID field:
    Object: Text Box
    --------------------------------------------------------------
    ControlName: ProductID
    OnDblClick: Get Parent Name
  4. Save and close Orders Subform.
  5. Open the Orders form. Double-click the ProductID field in the subform. Notice that the parent form name, Orders, is displayed in a dialog box.
  6. Close the Orders form. Open the Orders Subform form in Design view, and then remove the macro that you added in step 2.

REFERENCES

For more information about the Parent property, click Microsoft Access Help on the Help menu, type parent property in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Properties

Article ID: 209539 - Last Review: June 24, 2004 - Revision: 2.0
APPLIES TO
  • Microsoft Access 2000 Standard Edition
Keywords: 
kbhowto kbusage KB209539

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com