However, I agree that you may have a problem here. If the table called "tblCategoryList" has a single field called "Category", then the current design is appropriate. If, on the other hand, "tblCategoryList" has an ID field for its Primary Key (using the AutoNumber), then that is the appropriate field to be used in the combo box as the bound column, while the value field, "Category" would only be displayed to users.
Thanks guys for helping me solve my issue. Here is my working code:
' SELECT tblCategoryList.Category As Category, "1" As ID ' FROM tblCategoryList ' UNION ' SELECT "All Tags", 0 ' FROM tblCategoryList ' ORDER BY ID, Category;
Basically I created a row in SQL called ID and all records added from the tblCategoryList table are labeled 1 under ID. The Union adds the "All Tags" and under the ID column the row is identified with 0. Then I sort via ID and followed by Category. Now I can keep the order ascending and no matter what the "All Tags" remains on top.
Best Response confirmed by
AmedMesa (New Contributor)