Solved Sorting Report from Combo Box

[Pop_Access]

Hi;
I have a form that has a few parameters on it, and it has a button to open report; I want to add a combo box on the form (cmbsort) to allow end user sort the data on the report based on the combo box value.

Thank you

 

[CJ_London]

in reports, sorting is done in the report design. see this link https://social.msdn.microsoft.com/f...31f6e7/reports-changing-sort-order-on-the-fly

 

[gemma-the-husky]

it gets quite difficult programming all the sort orders that a user might want from a report.
In the end it can be a lot quicker and simpler to provide a spreadsheet extract, and let the user extract the information he wants.

 

[jdraw]

You may get some ideas from Martin Green's Dynamic Reports

 

[Pop_Access]

in reports, sorting is done in the report design. see this link https://social.msdn.microsoft.com/f...31f6e7/reports-changing-sort-order-on-the-fly

thanks for All,
I have used @CJ_London solution,

On the (On Open) event of the report you can set the order in this way

[Private Sub Report_Open(Cancel As Integer)

Dim sort As Variant
sort = Forms!frm_name.combo_name.Value

    If sort <> 0 Then
        Me.OrderBy = sort
    Else
        Me.OrderBy = "field_name"
    End If

End Sub