Search results

My question then is how to make picture 2 look like picture 3 without changing RecordSource?

The Benchmark table has many columns with IDs (BenchmarkCategoryID, TypeID, CountryID, MarketID...). If I join all of them, then form is not based on a table, but on a view. And I don't want to bring in extra fields into the form. Anyway, this was just a hack. The best way is to sort the form...

David, Have you read my original post carefully and understood my question? I don't see how your answer has any relevancy to my question. Please read the questions three times before you post any replies!

Here is BenchmarkCategory table. Notice the BenchmarkCategoryName is not sorted alphabetically when sorted by BenchmarkCategoryID. [See Picture 1] Here is another table Benchmark with a BenchmarkCategoryID column. I built a form on the table and added a ComboBox displaying the...