automationamateur
Board Regular
- Joined
- Jan 3, 2011
- Messages
- 166
I have a report that is fed by 'query123', and kicked off by 'form123'. I want to sort the report 4 different ways (individually not at the same time): 1. Client Name, 2. Accounts On file, 3. Margin %, and 4. Start Date. All of these sort options are separate fields in 'query123'.
I know there are a few options I've tried all with no success. 1. Sort the 'query123' data that feeds the report based on a combobox on 'form123'. This is easy enough if I want to sort on one field consistently but I need to be able to sort 1 of 4 fields based on user selection on form combobox. 2. Sort report 'On Load' event that sorts report based on selection in combobox on 'form123'. This only fired the form twice which doubled the time it took to run and it still didn't sort correctly. 3. Placed listbox on form itself and used an ******* event to resort the report based on user selection in the listbox. I couldn't get this to work either.
My ideal solution would be the form combobox to feed the query a sort field and then the data will feed report already sorted. If I need to resort I will rerun from the form and change combobox selection.
I've spent roughly 8 hours on this to no avail. Can anyone help me out here? I've tried every suggestion I could find on the net. If this even possible if my sort fields are 4 different fields? Thanks for the help in advance.
I know there are a few options I've tried all with no success. 1. Sort the 'query123' data that feeds the report based on a combobox on 'form123'. This is easy enough if I want to sort on one field consistently but I need to be able to sort 1 of 4 fields based on user selection on form combobox. 2. Sort report 'On Load' event that sorts report based on selection in combobox on 'form123'. This only fired the form twice which doubled the time it took to run and it still didn't sort correctly. 3. Placed listbox on form itself and used an ******* event to resort the report based on user selection in the listbox. I couldn't get this to work either.
My ideal solution would be the form combobox to feed the query a sort field and then the data will feed report already sorted. If I need to resort I will rerun from the form and change combobox selection.
I've spent roughly 8 hours on this to no avail. Can anyone help me out here? I've tried every suggestion I could find on the net. If this even possible if my sort fields are 4 different fields? Thanks for the help in advance.