[AccessD] Referencing Fields in Sub-Reports

Hi Mark

That sounds as if you have a misspelling.
What is the expression?

/gustav

>>> MarkBoyd at McBeeAssociates.com 05/18 5:24 pm >>>
Thanks Gustav.  
Logically, this looks like it should work.  Now, instead of "#Error",
the field is displaying "#Name?".

Mark Boyd
I/S Supervisor
McBee Associates, Inc.


-----Original Message-----
From: accessd-bounces at databaseadvisors.com 
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Gustav
Brock
Sent: Wednesday, May 18, 2005 10:23 AM
To: accessd at databaseadvisors.com 
Subject: RE: [AccessD] Referencing Fields in Sub-Reports

Hi Mark

Your problem is that the control doesn't even "exist" when there are
no
records.
Thus, you may need something like this (one line):

  IIf(Report!rptMain!<sub1>.Report.RecordsetClone.RecordCount = 0, 0,
Report!rptMain!<sub1>.Report!txtTextbox) +
  IIf(Report!rptMain!<sub2>.Report.RecordsetClone.RecordCount = 0, 0,
Report!rptMain!<sub2>.Report!txtTextbox)

/gustav