Returns a reference to the page that contains the control.
Read-only property
Set variable = object.Parent |
Page Object
Use the Parent property to get access to other controls on the same page without having to use their fully qualified paths. For example, a form named "frmMyForm" has a page named "pgPage1". This page contains two controls: "txtControl1" and "txtControl2". The code below uses the fully qualified path to access each control:
Dim objCtrl1, objCtrl2
Set objCtrl1 = Forms("frmMyForm").Pages("pgPage1").Controls("txtControl1")
Set objCtrl2 = Forms("frmMyForm").Pages("pgPage1").Controls("txtControl2")
By using Parent, the code can be shortened to:
Dim objCtrl1, objCtrl2
Set objCtrl1 = Forms("frmMyForm").Pages("pgPage1").Controls("txtControl1")
Set objCtrl2 = objCtrl1.Parent.Controls("txtControl2")
Dim objCtrl1, objCtrl2
Set objCtrl1 = Forms("frmMyForm").Pages("pgPage1").Controls("txtControl1")
Set objCtrl2 = Forms("frmMyForm").Pages("pgPage1").Controls("txtControl2")
By using Parent, the code can be shortened to:
Dim objCtrl1, objCtrl2
Set objCtrl1 = Forms("frmMyForm").Pages("pgPage1").Controls("txtControl1")
Set objCtrl2 = objCtrl1.Parent.Controls("txtControl2")