Referring to another control on a report

[Jacob Frankham]

Hi

I have a textbox on a report which I am trying to Sum in another textbox
control under a different grouping level

How do I refer to it because it says it is unknown and asks for input

ie

=IIf(Sum([the_textbox])=0, "N/A", Sum([a_field]))

It is still asking for a value for [the_textbox] - is there a cleverer way
of referring to the textbox?

Jake

 

[Jeff Boyce]

Jake

That usually happens if your reference is not completely accurate. The
expression looks something like:

Reports!YourReportName!YourReportControlName

Consider checking Access HELP for Expression and/or for Referring to ...

Good luck

Jeff Boyce
<Access MVP>

 

[Jacob Frankham]

Thats great, it works now !

Thanks Jeff