<div>
Is this a form with subform or report with subreports?<br><br>What are your link field(s) between your master and child subforms/reports?<br><br>Are you avoiding referencing fields rather than control names from the master? &nbsp;Here's a paper I wrote on that issue:<br><a href="https://www.fmsinc.com/microsoftaccess/Forms/Subform/Master-Link-Fields.asp" rel="ugc">https://www.fmsinc.com/microsoftaccess/Forms/Subform/Master-Link-Fields.asp</a>
</div>


<div>
The main form is a bound form and the three sub reports are linked to the main form by the Key field. They are, however, stand alone reports using their own query.<br><br>I see that the main bulk of your paper is about forms. That is usefull as I have had lot's of problems in the past with exactly that issue.<br><br>Regarding my report problem the key question is what could possibly be causing a 7 second delay until I delet some boxes and labels
</div>


<div>
This must be a corrupt form? How can I check
</div>


<div>
Why is your form using subreports instead of subforms? Or if you want a report, use a report instead of a form?&nbsp;
</div>


<div>
So sorry Luke I get so tied up with the issue that I make a mistake. It should read Main Report not main form.<br><br>I have done more testing and it seems that when the quality control boxes are in the report footer the report is running a function that is not called from the report. The underlying query uses it but the query runs perfect when the report is not active. When I remove the quality control labels and boxes section it does not run. I think there is something corrupt here. It makes no sense at all. I just recreated the exact same quality control boxes and labels manually, rather than copying and pasting from another report and problem has gone.
</div>


Derek Brown

<div>
This was the solution:<br><br><ol><li>For the Microsoft Access Runtime executable:-</li></ol>&nbsp;<br>C:\Program Files (x86)\Microsoft Access Runtime\Office10\MSACCESS.EXE<br>&nbsp;<br>In properties change the Compatibility Mode to Windows XP (Service Pack 3)<br>&nbsp;<br>&nbsp;<br><ol><li>Amend the following registry key to 50000 (Decimal)</li></ol>&nbsp;<br>HKEY_LOCAL_MACHINE\SOFTWARE\WOW6432Node\Microsoft\Jet\4.0\Engines\Jet 4.0\MaxBufferSize
</div>


<div>
<div class="content wysiwyg-content">
The attachments are the same report one with a quality control section<a href="https://filedb.experts-exchange.com/incoming/2020/05_w20/1455992/Capture.PNG" target="_blank" title="With section (29 KB)"><img alt="With section" class="file-block lazyload" style="max-width: 669px;" data-src="https://filedb.experts-exchange.com/incoming/2020/05_w20/1455992/Capture.PNG" /></a><a href="https://filedb.experts-exchange.com/incoming/2020/05_w20/1455993/Capture2.PNG" target="_blank" title="Without section (25 KB)"><img alt="Without section" class="file-block lazyload" style="max-width: 672px;" data-src="https://filedb.experts-exchange.com/incoming/2020/05_w20/1455993/Capture2.PNG" /></a> at the end of the report and the second is the same report with the quality control &nbsp;section deleted. The form with quality control takes 10 seconds to load and the other 3 seconds. <br />
<br />
I have tried deleting and copying the section from other reports that work fine.<br />
<br />
This form is a main form with three subforms in the report footer.<br />
<br />
What on earth could cause that?
</div>
</div>


Capture.PNG

Capture2.PNG

The attachments are the same report one with a quality control section at the end of the report and the second is the same report with the quality control  section deleted. The form with quality control takes 10 seconds to load and the other 3 seconds. 

I have tried deleting and copying the section from other reports that work fine.

This form is a main form with three subforms in the report footer.

What on earth could cause that?

Report Preview and Print

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.