Remove Sorting from Lookup Table

[Huddle]

I do not want the look up table for my combo box to sort the data so that the drop down will show the data the the order I enter it. The table automatically sorts the data even with the Remove Sort feature. I added another column with numbers and sorted it to put my data in order which works in the table but the drop down still sorts it alphabetically which I assume is because my number column is not the bound column.

Any suggestions on how to accomplish this?

[orange]

Please tell us/show us the record source for the combo.

[Huddle]

The record source is a simple table

[JoeM]

If you add an Autonumber field to your Lookup Table, the numbers will be in increasing order based on how the data is entered. You can then use that as your sort field so that it is sorted in the order they were entered (or I think if you make this Autonumber field the Primary Key or first field, it will use this is sorting automatically). Note that you do NOT have to display the Autonumber field in your Combo Box.

[Huddle]

Making the sorting number the primary key worked. Thanks.