[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
240-274-0069


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (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/efeae5d3/attachment.html>