About Us Tutorials Downloads Twitter Contact Us
{Search}
{Cart}
Looking to take your VBA skills further?...

Discover twinBASIC — a powerful new development platform that expands on VBA and VB6 with advanced features, modern tools, and enhanced compatibility. Perfect for those ready to elevate their projects or transition from VBA, twinBASIC lets you build on what you already know and take your applications to the next level!

Try out twinBASIC Community Edition - it's free!

Referring to properties and controls from a form/report

        21 votes: *****     14,32 views      1 comment
by Keri Hardwick, 01 January 1999    (for ALL VERSIONS of Access)

For these examples:

Mainform is the name of the top level form

Subform1 is the name of the subform CONTROL on mainform

Subform2 is the name of the subform CONTROL on the 1st subform.

  If you are on Download  Download Doc version
  Main form Sub 1
To refer to a form property, like RecordSource    
On Mainform Me.RecordSource Me.Parent.RecordSource
On Sub 1 Me!Subform1.Form.RecordSource Me.RecordSource
On Sub 2 Me!Subform1.Form!Subform2.Form.RecordSource Me!Subform2.Form.RecordSource
To refer to a control    
On Mainform Me!ControlName Me.Parent!ControlName
On Sub 1 Me!Subform1.Form!ControlName Me!ControlName
On Sub 2 Me!Subform1.Form!Subform2.Form!ControlName Me!Subform2.Form!ControlName
To refer to a control property, like Enabled    
On Mainform Me!ControlName.Enabled Me.Parent!ControlName.Enabled
On Sub 1 Me!Subform1.Form!ControlName.Enabled Me!ControlName.Enabled
On Sub 2 Me!Subform1.Form!Subform2.Form!ControlName.Enabled Me!Subform2.Form!ControlName.Enabled
To refer to a subform control property, like SourceObject    
On Mainform N/A N/A
On Sub 1 Me!Subform1.SourceObject N/A
On Sub 2 Me!Subform1.Form!Subform2.SourceObject Me!Subform2.SourceObject
     
  If you are on  
  Sub2 Not in these forms
To refer to a form property, like RecordSource    
On Mainform Me.Parent.Parent.RecordSource Forms!Mainform.RecordSource
On Sub 1 Me.Parent.RecordSource Forms!Mainform!Subform1.Form.RecordSource
On Sub 2 Me.RecordSource Forms!Mainform!Subform1.Form!Subform2.Form.RecordSource
To refer to a control    
On Mainform Me.Parent.Parent!ControlName Forms!Mainform!ControlName
On Sub 1 Me.Parent!ControlName Forms!Mainform!Subform1.Form!ControlName
On Sub 2 Me!ControlName Forms!Mainform!Subform1.Form!Subform2.Form!ControlName
To refer to a control property, like Enabled    
On Mainform Me.Parent.Parent!ControlName.Enabled Forms!Mainform!ControlName.Enabled
On Sub 1 Me.Parent!ControlName.Enabled Forms!Mainform!Subform1.Form!ControlName.Enabled
On Sub 2 Me!ControlName.Enabled Forms!Mainform!Subform1.Form!Subform2.Form!ControlName.Enabled
To refer to a subform control property, like SourceObject    
On Mainform N/A N/A
On Sub 1 N/A Forms!Mainform!Subform1.SourceObject
On Sub 2 N/A Forms!Mainform!Subform1.Form!Subform2.SourceObject

Rate this article:  Your rating: PoorYour rating: Not so goodYour rating: AverageYour rating: GoodYour rating: Excellent

Give me more tutorials!

Have your say - comment on this article.

What did you think of 'Referring to properties and controls from a form/report'?


1.

NANJUNDAIAH H N says...

08 Sep 2010

 
Referring to properties and controls from a form or a report is highly usefull when we have many subforms on the Main form, particularly when we are making office automation.


Have your say...

Name
E-mail (e-mail address will be kept private)
Comments

Comments require approval before being displayed on this page (allow 24 hours).

iTech Masters    |    VAT: GB202994606    |    Terms    |    Sitemap     |    Newsletter