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

SteveL13
SteveL13 used Ask the Experts™
on
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.

??
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Most Valuable Expert 2012
Top Expert 2014
Commented:
Reports handle sorting much differently, and will ignore the sorting set in a query. Instead, add a Sort to your report in Design view. The Grouping and Sorting box is shown at the bottom of the Design window. If you don't see it, click the "Group & Sort" item in the Grouping & Totals ribbon item.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial