MDE to MDB Conversion Service
ACCDE to ACCDB Conversion Service

IN THE SPOTLIGHT: MDE to MDB Conversion Service

(also supports: ACCDE to ACCDB, ADE to ADP, etc)

TELL ME MORE

Full restoration service (including source code) for MDE, ACCDE and ADE files

Access Database Repair Service

IN THE SPOTLIGHT: Access Database Repair Service

An in-depth repair service for corrupt Microsoft Access files

TELL ME MORE

Professional, friendly service for repairing corrupt Microsoft Access files (MDBs, ACCDBs, etc)

vbWatchdog

IN THE SPOTLIGHT: vbWatchdog

VBA error handling just got easier...

" vbWatchdog is off the chart. It solves a long standing problem of how to consolidate error handling into one global location and avoid repetitious code within applications. "

- Joe Anderson,
Microsoft Access MVP

Meet Shady, the vbWatchdog mascot watching over your VBA code →
(courtesy of Crystal Long, Microsoft Access MVP)

TELL ME MORE

vbWatchdog: A unique code library offering global error catching for your VBA & VB6 projects.

vbMAPI

IN THE SPOTLIGHT: vbMAPI

An Outlook / MAPI code library for VBA, .NET and C# projects

Get emails out to your customers reliably, and without hassle, every single time.

Use vbMAPI alongside Microsoft Outlook to add professional emailing capabilities to your projects.

TELL ME MORE

vbMAPI: An easy-to-use Outlook / MAPI code library for VBA, .NET and C# projects.

Code Protector

IN THE SPOTLIGHT: Code Protector

Standard compilation to MDE/ACCDE format is flawed and reversible.

TELL ME MORE

Protect your valuable intellectual property, by securing your MDE/ACCDE projects using Code Protector

twinBASIC

Referring to properties and controls from a form/report

21 votes:

14,34 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 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

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...

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

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

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