[GUIDE] Refer to Microsoft Access Form, Subform properties and controls
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