I have a Form i have created to pull reports out of a SQL database. Everything has been working well up to the point where I have been tasked to make the user able to sort the report on the fly. meaning i have a combo box that has the following Row Source = "Mail Date";"Due Date";"CustName" I also have a list of about 15 reports to pick from. Basically I have all the reports Sort by = "Mail Date" and now they want me to make it so they can select from "Mail Date";"Due Date";"CustName" which are the same names of the fields in the query. I have been trying to get this to work for 2 days now and just can not figure out how to get this done. I am fairly new and self taught so any help you could give me would be GREATLY appreciated.
I tried viewing the supporting query in SQL and then change the Order By [Forms]![frmReports]![Combo70] and that didn't work. I tried doing an event procedure in my preview command button and that didn't work. I've tried a bunch of things but like I said i am fairly new at this and am not sure if I am even scripting it correctly. Any help would be great.
Thanks