[AccessD] What to do when subreport used as textbox source h as no data

Drew Wutka DWUTKA at marlow.com
Wed Oct 8 18:22:41 CDT 2003


Just a thought, on the OnFormat of each subreport, go and 'add' the fields
to that other textbox, that way, if there is no data for a subreport, there
won't be an OnFormat event.
 
Drew

-----Original Message-----
From: Nancy Lytle [mailto:LYTLEN at peoplepc.com]
Sent: Wednesday, October 08, 2003 6:01 PM
To: AccessD at databaseadvisors.com
Subject: [AccessD] What to do when subreport used as textbox source has no
data



I have a main report with 3 subreports, all are related by the field
ProgramCode.  There is a record in three of the reports (Main and 2
subreports) for every ProgramCode.  I also use the values in the subreports
to populate a text box - txtAB = Sub1.field + sub2.field- sub3.field -
sub3.field.  This works fine except for the case where the ProgramCode has
no record in Subreport3, then that subreport doesn't show and the textbox is
filled with error#.  How do I get the textbox to use txtAB = Sub1.field +
sub2.field where there is no sub report for the linked field.

Hope I explained this okay.
TIA
Nancy L


N_Lytle at terpalum.umd.edu <mailto:N_Lytle at terpalum.umd.edu> 
240-274-0069
 

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system ( http://www.grisoft.com
<http://www.grisoft.com> ).
Version: 6.0.524 / Virus Database: 321 - Release Date: 10/6/2003

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20031008/509bedf6/attachment-0001.html>


More information about the AccessD mailing list