Using option boxes to sort data

  • Thread starter Thread starter dawn
  • Start date Start date
D

dawn

Hi,
I would like to use an option box with 8 choices on a
form to sort a report. So if option 4 is selected the
report will be sorted in descending order by option 4.

Thanks
 
You can use the Open event of the report to set the ControlSource of the
GroupLevel. Details:
http://allenbrowne.com/ser-33.html

If the report has nothing in its Sorting'n'Grouping, an alternate approach
would be to set its OrderBy property in Report_Open, remembering to set
OrderByOn as well.
 
Back
Top