[GUIDE] Refer to Microsoft Access Form, Subform properties and controls

Posted on Posted in Access 2010 No Comments Tagged with , , , , ,

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

David Gregory Medina

Post created by: David Gregory Medina

Leave a Reply