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>