lemmiwinks30
Programmer
Hello,
I know some variation of this question has been asked, but I can't seem to make this work.
I have a form that feeds a report. On the form, using a combo box the user may request items to be descending or ascending order. My report uses grouping and of course Access forces you to choose a sort order. How can I override the sort order to be based on what the user chooses?
So basically, the query that is built based on what the user enters on my form is overridden by the Sorting and Grouping property on the report.
Any help I appreciate.
Thanks,
Kathy
I know some variation of this question has been asked, but I can't seem to make this work.
I have a form that feeds a report. On the form, using a combo box the user may request items to be descending or ascending order. My report uses grouping and of course Access forces you to choose a sort order. How can I override the sort order to be based on what the user chooses?
So basically, the query that is built based on what the user enters on my form is overridden by the Sorting and Grouping property on the report.
Any help I appreciate.
Thanks,
Kathy