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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Programmatically control Report Grouping & Sorting via Form 1
Query used for Report 7
Access2007: CustomReport - User entered Sort order 0
option buttons not showing that they are selected 4
Sorting day names chronologically 5
Column Orders 1
Pass option box selection to combo box query criteria 6
Sort Single/Double Digit Values 2

Back
Top