Hello;

I created a form which enables a user to select 1 of 3 reports and filter
them using a series of combo boxes.  I now want to create an option box which
would enable him/her to sort the data by the field chosen in the option box.  

My filters are created dynamically using vba code and stored into the
strWhere clause.  They are then executed using:

DoCmd.OpenReport "rpt_Merchant", PrintMode, , strWhere

I now want to add the order by statement, and was hoping to add it to the
strWhere clause

strWhere = strWhere & " ORDER BY " & "Regions.Region"

This however doesn't work.  Is there an easier way to go about this.

Any help would be much appreciated.

Thanks
ACase