Hi, I want to design a forum where the user can select a field they want to order the search result by. So far, I've tried doing:
ORDER BY [forms]![Form1]![Combo1];
Where Combo1 is a drop down list of bunch of valid field names. However, this doesn't seem to do anything. The query gets executed from the form without error but it isn't ordered by the field I selected. Any help would be appreciated.
ORDER BY [forms]![Form1]![Combo1];
Where Combo1 is a drop down list of bunch of valid field names. However, this doesn't seem to do anything. The query gets executed from the form without error but it isn't ordered by the field I selected. Any help would be appreciated.