Sorting and Grouping - Please Help

[Jon via AccessMonster.com]

Hi Guys,

My "Sorting and Grouping" in my report looks like this:

Field/Expression Sort Order
sID Ascending
((= Project Name Ascending
User *** Ascending
((= rID Ascending

The "((=" is Group Header = Yes

I have a form that has a 'create report' button that opens this report.

I am trying to make a list/combo box in the same form that the user can choose a field and when they click the 'create report' button it will change the third field (***) to whatever the user selected in the list.

eg. i want to be able to have the same report sorted by Priority or Status or User etc...

Is this possible? does anyone know the code i can use in the 'create report' button...

Thanks for any suggestions!

 

[Marshall Barton]

My "Sorting and Grouping" in my report looks like this:

Field/Expression Sort Order
sID Ascending
((= Project Name Ascending
User *** Ascending
((= rID Ascending

The "((=" is Group Header = Yes

I have a form that has a 'create report' button that opens this report.

I am trying to make a list/combo box in the same form that the user can choose a field and when they click the 'create report' button it will change the third field (***) to whatever the user selected in the list.

eg. i want to be able to have the same report sorted by Priority or Status or User etc...

Add code to the report's Open event procedure:

Me.GroupLevel(2).ControlSource = Forms!theform.thecombobox

 

[Jon via AccessMonster.com]

You're a GUN!!!!!! thanks!!