Sorting a report using combo box on a form.

[sanjayakalpage]

Dear friends,
I have a form with a combo box named"sort by" with field headings as its values. And the form has a button to open a report. when click on the button how can I sort the report using the field selected by the combo box.
Thank u...

[June7]

I've never done this but maybe the Order By property of report can reference the combobox. However, if the report uses Grouping & Sorting features, will probably override the Order By property. In which case, an expression in the report Grouping & Sorting set up could probably reference the combobox. Again, never tested.