E
Euclid
I have several subforms under tabs on a main form. I have to refer to values
found in subform controls in other subform controls. In all of the cases
where I've needed to do this I've had no trouble using syntax such as the
following:
=[Forms]("MAINFORM")("SUBFORM").[Form].[Controls]("TEXTBOX")
or
=Forms!MAINFORM!SUBFORM!TEXTBOX
Now, for some reason, I've run into a blank wall, literally. In the text
box where I've put the reference, nothing appears, not even "#Name?". I've
changed the syntax several times, once in awhile getting "#Name?" but after
changing the syntax I've gotten nothing again. Naturally, I've checked the
VISIBLE property. The value I'm trying to get is from another subform
reference-it's own subform, in this case and that is appearing just fine.
I've even tried to bypass the first subform and get the value directly from
its nested subform but again nothing appears.
In another situation in the same database the value that's returned is
different from what is in the referenced text box. Of course, I've checked
and double checked the control names but that doesn't seem to be the problem.
This is really bizarre. I've compacted and repaired several times also.
Could someone help me with this?
found in subform controls in other subform controls. In all of the cases
where I've needed to do this I've had no trouble using syntax such as the
following:
=[Forms]("MAINFORM")("SUBFORM").[Form].[Controls]("TEXTBOX")
or
=Forms!MAINFORM!SUBFORM!TEXTBOX
Now, for some reason, I've run into a blank wall, literally. In the text
box where I've put the reference, nothing appears, not even "#Name?". I've
changed the syntax several times, once in awhile getting "#Name?" but after
changing the syntax I've gotten nothing again. Naturally, I've checked the
VISIBLE property. The value I'm trying to get is from another subform
reference-it's own subform, in this case and that is appearing just fine.
I've even tried to bypass the first subform and get the value directly from
its nested subform but again nothing appears.
In another situation in the same database the value that's returned is
different from what is in the referenced text box. Of course, I've checked
and double checked the control names but that doesn't seem to be the problem.
This is really bizarre. I've compacted and repaired several times also.
Could someone help me with this?