Sort Order

[David]

I have a generic query which is the control source of a
report. I need four different sort orders based on the
radio button on a form, can I change the sort order of the
report on open based on the radio buttons ?

 

[Jeff Boyce]

David

Given that sort order in a report is handled in the report (and not in the
underlying query), yes. You'll need to look into writing some code behind
the report, perhaps in the OnOpen event. You can refer back to the form (it
will have to remain open) and to the option group value to help set sort
order.

Good luck

Jeff Boyce
<Access MVP>