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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DLookup in Continuous form 0
Requery main form after subform update and not lose place in main form. 3
OLe Object ? 0
Subform of a subform 1
Referring to control in the active subform 0
Referencing to a control on a subform 1
Create a SubForm on a Tab Control 0
Referencing subform from another subform 11

Top