referencing subform controls

J

Junior

I have a Form with two subform layers
the example below correctly references the first subform control

strPPln = Nz(Me.[sfrmEOD].Form![PAYPLAN], "ZZ")

I want to reference a control on sfrmEODOne which is a sfrm on sfrmEOD
how do i reference a subform control that is 2 layers from the mainform
 
K

Ken Snell

Try

strPPln = Nz(Me.[sfrmEOD].Form.sfrmEODOne.Form!ControlOnSubSubForm, "ZZ")
 
J

Junior

thank you
Ken Snell said:
Try

strPPln = Nz(Me.[sfrmEOD].Form.sfrmEODOne.Form!ControlOnSubSubForm, "ZZ")


--

Ken Snell
<MS ACCESS MVP>

Junior said:
I have a Form with two subform layers
the example below correctly references the first subform control

strPPln = Nz(Me.[sfrmEOD].Form![PAYPLAN], "ZZ")

I want to reference a control on sfrmEODOne which is a sfrm on sfrmEOD
how do i reference a subform control that is 2 layers from the mainform
Click to expand...
Click to expand...
 
Top