Referring to properties and controls from a form/report

        21 votes: *****      13,969 views      1 comments
by Keri Hardwick, 01 January 1999    (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: Poor Your rating: Not so good Your rating: Average Your rating: Good Your rating: Excellent



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 September 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
Verify Code
Verification Code


It may take 30 seconds after clicking submit - please be patient to avoid duplicate submissions.  

All comments must be approved before being displayed on this web page.  This process may take up to 24 hours.