Sort Columns

[Kokanutt]

I design ad hoc report form that users use to create reports based on
requirements. users are able to choose up to 10 fields in order of preference
1st, 2nd, 3rd, 4th, etc. the 10 combo boxes are in vertical position (1 field
under the other). the combo boxes are unbound with a Row Source Type as Field
List and a query as the Row Source. to the left of each combo box are other
options such as align, width, sorting, etc. what i would like to do is after
the user selects fields need for their report is have the ability to move a
particular field up or down to change the order in which the field will
appear on the report. is there any code to do this. Thanks for any feedback

 

[Allen Browne]

See:
Sorting report records at runtime
at:
http://allenbrowne.com/ser-33.html

The article illustrates how to set the ControlSource of a GroupLevel in the
Open event procedure of the report. Provided you have created the group
levels at design time, you can adapt this code to handle multiple levels of
grouping.