I have a form setup so that my users can define the filters they want on their report which is just a query. I am having some trouble though because I am not sure how to setup the filter so that the user can choose the order in which they want the query sorted. I was using combo boxes with field names, but I can't seem to get the sql to recongnize the value of the combo box as the field name. Here is what I currently have as my order by statement.
FROM [CARCASS DATA CALCULATIONS]
ORDER BY FORMS.[CARCASS FILTER].COMBO32;
CARCASS FILTER IS FILTER FORM
CARCASS DATA CALCULATIONS IS THE QUERY I AM QUERYING.
FROM [CARCASS DATA CALCULATIONS]
ORDER BY FORMS.[CARCASS FILTER].COMBO32;
CARCASS FILTER IS FILTER FORM
CARCASS DATA CALCULATIONS IS THE QUERY I AM QUERYING.