Subform on a Subform

G

Graham Naylor

Hi,

I've got a form "AAA" on which is a subform "BBB" and on this subform is
another subform "CCC", also on "BBB" is a text control "TTT".

From code attached to the lower subform (Form_Current section) "CCC" how do
I refer to the control on the subform "BBB".

I've tried the Forms!"BBB""TTT.text format but this fails with the error
"Access cannot find the form "BBB" refered to"

I've also tried the format Forms!"AAA"!"BBB""TTT.text but this error "Access
cannot find the field refered to in your expression".

I've double checked all form/control names and everything checks out.

Regards

Graham
 
Top