<div>
<div class="content wysiwyg-content">
I have a form that has a sub-form. &nbsp;I have been able to make the sub-form sort the records in descending order by setting OrderBy = [ItemN] in the Form Data properties.<br />
<br />
But I have a report opening from a command button on the form and the details in the sub-report WILL NOT sort in the proper order even though the record source for the sub-report is a query with the field ItemN set to descending.<br />
<br />
??
</div>
</div>


I have a form that has a sub-form.  I have been able to make the sub-form sort the records in descending order by setting OrderBy = [ItemN] in the Form Data properties.

But I have a report opening from a command button on the form and the details in the sub-report WILL NOT sort in the proper order even though the record source for the sub-report is a query with the field ItemN set to descending.

??

Trying to get a sub-report to open sorted by ItemN

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.