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

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

Anyone...??

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.