Access 2003 - Is the easiest way to sort by changing the recordsource?

[RiceRocket]

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!!!

[RiceRocket]

Anyone...??

[salvelinus]

This (parameter) issue can happen when your query asks for a field that doesn't exist in the table (misspelled, perhaps?). At least that's when it's happened to me.