Subform within a subform

[Guest]

Good Morning,
I have a Form that has a subform and that subform has another subform in it.

I cant seen to be able to reference it.

EX: Textbox control - =Forms![MyForm].[MySubform].[Mysubform2]!tbText
For some reason that code will not work, it just says #name? in the textbox.

I have triple checked all the spelling and have tried more than 1 textbox
and combox, I cant get any of them to work.

Any Ideas?

Thanks.

 

[Roger Carlson]

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SubformReference.mdb" which illustrates how to reference
subsubforms.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

 

[Guest]

Thanks Roger.
That got it working =)

On my website (www.rogersaccesslibrary.com), is a small Access database
sample called "SubformReference.mdb" which illustrates how to reference
subsubforms.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L

Good Morning,
I have a Form that has a subform and that subform has another subform in it.

I cant seen to be able to reference it.

EX: Textbox control - =Forms![MyForm].[MySubform].[Mysubform2]!tbText
For some reason that code will not work, it just says #name? in the textbox.

I have triple checked all the spelling and have tried more than 1 textbox
and combox, I cant get any of them to work.

Any Ideas?

Thanks.