The Sort feature works fine when the recordset is setup with no filters. As soon as I add a WHERE statement, I get the following error when clicking the link to sort:
Microsoft OLE DB Provider for SQL Server error '80040e14'
Incorrect syntax near the keyword 'ORDER'.
It points to line 117 - "Set rsDisplayData = rsDisplayData_cmd.Execute"
How can I implement a WHERE filter and still allow the sorting to function?