referencing subform controls

  • Thread starter Thread starter Junior
  • Start date Start date
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
 
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...
 
Back
Top