Hi all,
I am trying to sort my records in a subform (in continuous view). The way in which I am implementing this is by giving the user a combobox from which they can select a column header by which to sort. Once they have made their choice, I am trying to sort all the records based on the column header chosen. I am attempting to sort by setting the RecordSource property of the subform that my records are in. I defined 5 queries, each of which have the ORDER BY property set to one of the column headers. When the user chooses an option in the combobox, I set the RecordSource property of the subform to the corresponding query. What ends up happening, however is that for some of the items in the column, it brings up a dialog box asking for a parameter value. For example, if i were to sort by priority, there will be a dialog box asking for the parameter value of "Medium". I can click OK without entering a value, but the records are still not sorted (same thing happens if i enter a dummy value). Also, what is the best way to implement this same sort when the records are filtered? Any help is ALWAYS GREATLY APPRECIATED!!! Thanks is advance everyone!!!