Combobox not sorting

[bd528]

Hi all,

I have a combobox with a row source of :-

SELECT tblBrokerages.ID, tblBrokerages.Brokerage_Name FROM tblBrokerages ORDER BY tblBrokerages.Brokerage_Name;

The bound column is 1 and the column count is 2

When new entries are added to tblBrokerages, they appear at the bottom of the combobox, however, I'd like the combobox in alphabetical order. Despite the row source above, the combobox remains in tblBrokerages.ID order.

Can anyone confirm what needs to be changed? Thanks in advance.

 

[Ranman256]

Check the cbo property 'sorted'. It may be on.
If not, in the query swap the field order, make name the 1st column and sort it.
And set bound col =2.

 

[bd528]

If not, in the query swap the field order, make name the 1st column and sort it.
And set bound col =2.

This worked. Thank you.