Sorting a report

[Andrew]

Hello.

I need to sort a report (the report is based upon the
results of a query). I would like to be able to select on
a form which field I would like to sort by, eg generate a
report which is sorted in order of date, ref #, name etc
etc - but have a combo box to select which field.

I have tried this by having a combo box display the
available fields then under Sorting And Grouping in the
reports design window I have entered an expression to get
the contents of the combo in the format [Forms]!
[FormName].[Combo] but this doesn't appear to work.

I'm quite new to Access so sorry if this is obvious.

Andrew

 

[Allen Browne]

You can use the Open event of the report to set the ControlSource of the
Group Level.

Andy Baron explains how in article:
Sorting Records in a Report at run-time
at:
http://members.iinet.net.au/~allenbrowne/ser-33.html

 

[Duane Hookom]

Allen Browne has code at his web site
http://members.iinet.net.au/~allenbrowne/ser-33.html.

 

[Guest]

Many thanks to you both.

Andrew