Arthur Fuller
artful at rogers.com
Fri Sep 9 17:23:10 CDT 2005
Shamil recently assisted me with the syntax to refer to a control on a
subform, and now I need to do the opposite from within a "With Me" block. I
tried "Parent" as in the following sample line, with a couple of variations,
but I got it wrong.
With Me
.Parent.MyControl = 12345
.Parent.Form.MyControl = 12345
.Parent.Form.MyControl.Value = 12345
End With
And another thing about these "With Me" blocks. It appears from my
experiments that you cannot nest them. I.e.
With Me
.control1 = 124
.control2 = "This is some text"
With .mySubForm
.control1 = True
.control2 = "This is some more text"
End With
End With
Whereas one can next Case blocks, While loops, If blocks, etc. Can anyone
think of a logical reason why With blocks do not conform to the general
rule?
TIA,
Arthur