J
jeditig
Guest
Okay, very simple concept yet i cant figure out how to do it. I have one table. I want to have the user be able to use a drop down box on a generic form "welcome screen" to select which field (column) he or she wants to sort the records by. Then click a button which opens a report based on the table which is sorted (ordered) by the field the user selected in the form drop down.
I made a "Field List" selection box based on the table on the form. And in the report, I entered the path to that selection box in the OrderBy property field. i made sure OrderBy was selected to on.
This does not work, the report will not sort. My table has about 55 fields and I dont want to create queries for each one so the user can sort.
I am stumped, anyone, please help, there has to be a way to do this, why else would you create a "field list". -- jason
I made a "Field List" selection box based on the table on the form. And in the report, I entered the path to that selection box in the OrderBy property field. i made sure OrderBy was selected to on.
This does not work, the report will not sort. My table has about 55 fields and I dont want to create queries for each one so the user can sort.
I am stumped, anyone, please help, there has to be a way to do this, why else would you create a "field list". -- jason
