<div>
Many thanks - worked a treat
</div>


<div>
<div class="content wysiwyg-content">
HI<br />
<br />
I have an Access Report that contains a sub report. &nbsp;The main form has control that references a total box on the sub report. &nbsp;This all works fine until the sub report contains no data and then the control that references it on the main form display #error.<br />
<br />
How can I get around this?<br />
<br />
Many thanks
</div>
</div>


HI

I have an Access Report that contains a sub report.  The main form has control that references a total box on the sub report.  This all works fine until the sub report contains no data and then the control that references it on the main form display #error.

How can I get around this?

Many thanks

MS Access Report error

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.