Sorting a combo box

[gary g]

I have a combo box on my form where Row Source=Facilitators and Row Source Type=Table/Query. "Facilitators" refers to a one column table named Facilitators. This one column table contains a list of last names of a dozen or so staff members. The field name of this column I just left as Field1 (the default name). In table view I sorted the last names in ascending order.

When I open the combo box on the form itself, the list of names appear in random order instead of keeping the ascending sort order that I initially applied to the table.

I know there is a way for the combo box to keep the sort order in tact, but I can't recall what it is. Can someone help? Thanks.

 

[missinglinq]

1. Create a Query off of the Table
2. Sort the Field in the Query
3. Base the Combobox on the Query

Linq ;0)>

 

[gary g]

To Missinglinq: Sorry for the late response. Your suggestion worked perfectly and only took me a few seconds to fix. I recall doing it a different way the last time, which seemed more convoluted. I really appreciate your quick reply and showing me a much quicker way of sorting. It's always the little things in life that make one's day!

 

[missinglinq]

Glad we could help!

Linq ;0)>