sort order in report

[Michel Peeters]

I have a report with in the sorting-grouping box:

Level 1: group with header
Level 2: is the detail - sorted on expression: =Forms!fdlgRptWeek!cboSort
cboSort is a combobox with a value list with field names from my report.
But for an unknown reason this does not work.
When I replace "=Forms!fdlgRptWeek!cboSort" with a fieldname the report is
sorted as asked.
I checked the value from cboSort by assigning it to a stringvariable: the
value is the correct fieldname.

How can I sort the reportdetail on the value from the combobox in my form?

michel

 

[Allen Browne]

See:
Sorting report records at runtime
at:
http://allenbrowne.com/ser-33.html

The article explains how to use the Open event of the report to set the
ControlSource of the GroupLevel.

 

[Duane Hookom]

You can't reference a control on a form since it has only one value... the
name of the field, not the values contained in the field.

Allen Browne has code at http://www.allenbrowne.com/ser-33.html.