Sorting and Grouping - Please Help

  • Thread starter Thread starter Jon via AccessMonster.com
  • Start date Start date
J

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!
 
Jon said:
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...
Click to expand...


Add code to the report's Open event procedure:

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