Forms: Refer to Form and Subform properties and controls

Home | French | About | Search | mvps.org


	What's New Table Of Contents Credits Netiquette 10 Commandments Bugs Tables Queries Forms Reports Modules APIs Strings Date/Time General Downloads Resources Search Feedback mvps.org In Memoriam Terms of Use

Forms: Refer to Form and Subform properties and controls

Author(s)

Keri Hardwick

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