Problem with Subreport

[rnutts]

Hi

I have a costing database. With a structure of tblenquiry where the primary key (enquiryNo)appears as the foreign key in tblparts, tbllabour and tblpaint
Not all enquiries will have all three parts, labour and paint. This is giving me a problem when I run estimate report to show the total of paint parts and labour, the one where no records exist is showing a #error# on the report.
The estimate report is run off a query taking information from the tblenquiry, I then have three subreports for parts, paint and labour. I then have text boxes on the main report pointed to the appropriate text box on the sub report, this is the box showing the #error#
I have tried the following in the control source line of the text boxes but this does not work
=IIf(IsNull(rptEnquiryPartCalc.Report!SumPartCost),0,rptEnquiryPartCalc.Report!SumPartCost)
Has anyone any other thoughts to eliminate this other than for me to code this into the original enquiry so that every enquiry has a record in each table.

thanks

Richard

 

[rnutts]

Using the similar threads at the bottom on the post I found an answer on Allen Brownes website. Link below for others if needed


http://allenbrowne.com/casu-18.html

 

[vbaInet]

Thanks for posting back with a solution.