Alphabetize cascading combobox results

[Kevo]

Good afternoon,



I have a form that has cascading comboboxes. I choose the "Department" from the first combobox & then the 2nd combobox offers all the instruments that belongs to that department. Here is my question.....

When you enter into 2nd combo box and start typing....let's say your looking for "Major Instrument Set" - so you start typing "Maj.... and it autofills what it thinks you want.....and you can click on the dropdown arrow and it shows the list of all instruments. The problem is this drop down list is not alphabetical, so, you type "Maj and the next item in the drop down may be "hemostat" or "needle holder".

What I would like it to do is.....start typing "Majo (for Major Instrument Set) and the first items on the dropdown list would be..... "Major Basin"....then "Major Instrument".... then "Major Whatever"

So, Can you alphabetize the drop down list of a combo box?

Thanks,
Kevin

[June7]

Include ORDER BY clause in the combobox RowSource query.

[Kevo]

Include ORDER BY clause in the combobox RowSource query.

I believe it is already set to ORDER BY....but it is not behaving correctly. Possibly has something to do with the cascading combo box?

I have attached my DB if anyone has time to look at it.

Main Menu --> Sterilization Menu --> Add New Load --> pick a department under DepartmentID and then pick an instrument under InstrumentIDSPD.zip.....the instrument drop down list is the one I am trying to come up alphabetized.

Thanks for any help!

Kevin

[June7]

Only SetID combobox in frmLoadDetails subform has ORDER BY clause. Fix the RowSource and combobox list will sort.

[Kevo]

Thank you so much June7!