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
 
P

PC Datasheet

From AAA:
Me!NameOfSubformControlOnAAA!TTT
From BBB:
Me!TTT


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
 
G

Graham Naylor

Thanks,

What code from form "CCC" ?

Thanks


PC Datasheet said:
From AAA:
Me!NameOfSubformControlOnAAA!TTT
From BBB:
Me!TTT


--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications
(e-mail address removed)
www.pcdatasheet.com
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

Do Until Loop help 1
RecordsetClone on a subform 3
Pulling Sequence Number Depending on Other Fields 6
Subform of a subform 1
Syntax for Referring to a subform 3
Referencing to a control on a subform 1
adding and removing subforms from subform controls 4
subform total behaving strangely 2

Top