value in textbox of a subform of subform of main form

G

Guest

Hi,
I have a textbox 'RecNo' in the mainform. I have a subform in the mainform.
I have subform in the subform of the mainform. I need to get the value of
RecNo in the innermost subform.
I tried forms!mainform!subform!subform.textbox but doesn't work... :(

Thanx :)
 
A

Allen Browne

Try:
Forms!mainform!subform.Form!subform.Form.textbox

For an explanation of the ".Form" bit, see:
Referring to Controls on a Subform
at:
http://allenbrowne.com/casu-04.html

Note that "subform" must the the name of the subform control, which is not
necessarily the same as the name of the form it contains (its SourceObject.)
 

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

data entry in subform before mainform causes huge hassle, HELP! 2
Total of Subform 1
check box auto populate 2
Counting in Subform 3
Group checkboxes on subform 5
Set Change Event on Control from Nested Subform 0
Unbound Combo Refresh 1
Filter Parent Form by Subform's Listbox Selection 2

Top