MultipleSubforms.JPG

<div>
Hi Pat,<br />
<br />
Thanks for your response. Not exactly the solution I had in mind, but nonetheless pointed my thoughts in an appropriate direction and I have now resolved the issue.<br />
<br />
Although not a technical result it did prompt the old grey matter and allowed me to see a solution using conditional formatting that serves my purpose well enough, so thanks for that.<br />
<br />
LJS
</div>


Hi Pat,

Thanks for your response. Not exactly the solution I had in mind, but nonetheless pointed my thoughts in an appropriate direction and I have now resolved the issue.

Although not a technical result it did prompt the old grey matter and allowed me to see a solution using conditional formatting that serves my purpose well enough, so thanks for that.

LJS

<div>
<div class="content wysiwyg-content">
I have an access form that I am using to record test results for a specific process.<br />
<br />
I want to show the results in a sub-form table below the header data, but the data may be in excess of 100 records, so will need to show the results in multiple columns, say 5, rather than one continuous column.<br />
<br />
Can anyone point me in the right direction please?<br />
<br />
Thanks
</div>
</div>


I have an access form that I am using to record test results for a specific process.

I want to show the results in a sub-form table below the header data, but the data may be in excess of 100 records, so will need to show the results in multiple columns, say 5, rather than one continuous column.

Can anyone point me in the right direction please?

Thanks

Adding a List of Results in Access

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.