Sub Subform

[Cathy]

I have three forms:

frmProcessControls - Main form
subProcessControls - subform
subsubProcessControls - sub subform

From the subform (subProcessControls)I need to refer to a field on the
subsubform (subsubProcessControls). What is the naming convention?

Thank you,
Cathy

 

[Arvin Meyer [MVP]]

Me (or Forms!SubformName!)

Me.SubformControlName.Form.ControlName

It should be exactly the same as when referring to a subform from a
mainform.

 

[Cathy]

Arvin,

Something still isn't working. I must be misunderstanding something. My
control name on both the subform and the subsubform is Frequency. On the
subform I am trying to apply conditional formatting looking at the
subsubform. So, given your naming convention would I use:

me.subProcessControls.frequency.Form.Frequency
or
me.subProcessControls.frequency.subsubProcessControls.frequency...

None of it's working... so I know I'm not getting something.

Thanks
Cathy

 

[Arvin Meyer [MVP]]

No, it would be:

me.subProcessControls.Form.Frequency

It is Me, which refers to the active form where the code is currently
running.

NameOfSubformControl, (subProcessControls) which is often the same name as
the subform

..Form which refers to the Form property of the subform control

..Frequency which is referring to the textbox, named Frequency
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com