Link to home
Start Free TrialLog in
Avatar of SteveL13
SteveL13Flag for United States of America

asked on

Is there a way to use an option group on a form to open a report with the data in either ascending or descending order?

Is there a way to use an option group on a form to open a report with the data in either ascending or descending order in the detail section of the report?
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of SteveL13

ASKER

There is no grouping on the report.  I'll try this.  

You wrote, "In the Open event of the form, use code like this:" but I assume you meant open event of the report, correct?
Yes - in the Open event of the REPORT. Sorry about that.
No problem.. I understood and accepted your solution.  Thanks much!