Referring to another control on a report

  • Thread starter Thread starter Jacob Frankham
  • Start date Start date
J

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
 
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>
 
Back
Top