Grouping and Sorting problem :confused:

[jlocke]

I have a report that was being sorted by an option box which allowed me to select which filed to set the sort by option. I had to make a changes to the report design to group by "Property Address" using the Grouping and Sorting options, now when i select a different sort option in my option box the selection gets ignored. I don't want to my several version of the same report to accomodate this issue.

Thank you

 

[jlocke]

sorting grouped reports

Why wouldn't make sense? i want grouped items and then want to be able to sort on different fields, say i want sorting on column A then another time sort on column B or C?

Joe

 

[ThreeCrow]

Place Code in the On Open event of the Report
To do your Sorting,

Something like the following

Private Sub Report_Open()
If Forms!YourFormName!CheckBoxA = True Then
Me.OrderBy = "ColumnA"
Else
If Forms!YourFormName!CheckBoxB = True Then
Me.OrderBy = "ColumnB"
End If
Me.OrderByOn = True
End If

You'll have play with it a little bit

Hope this helps, I not strong in writing Code