How do i sort a combo box when finding a record on a form?

[wcook101]

I have a database of parts and some parts have the same part number but different manufacturers. I set up a simple combo box to search the 20k records and it works fine to a point. I noticed when i typed in LM324N that it didn't sort the parts at all and about 5 rows down i see another LM324N.
How can i sort so it shows all the parts of different manufacturers?
Thanks

[Bob Fitz]

Assuming the combo box is based on a query then sort it in that query

[orange]

What is the rowsource of the combo?

You'd have a query along this set up (but we need more info/details)

SELECT Parts.* from Parts
Where Parts.[Part Number] = YourComboBox
ORDER BY Parts.[Part Number]

[wcook101]

I just did this, and now it works fine
SELECT [STOCK].[ID], [STOCK].[PartNumber], [STOCK].[MFR], [STOCK].[QOH] FROM STOCK ORDER BY PartNumber;

Im just curious why the combo box wizard doesn't ask if you had any sort order in mind.

[Bob Fitz]

I've never noticed that when creating a combo to find a record. It certainly gives sort options for other type of combo 🙂

[wcook101]

Right, I know. Its pretty weird. I thought maybe I was doing something wrong. I couldn't understand why there was no sort option. I definitely think MS missed this one.

[Bullschmidt]

I have a database of parts and some parts have the same part number but different manufacturers. I set up a simple combo box to search the 20k records and it works fine to a point.
...
How can i sort so it shows all the parts of different manufacturers?
...
I just did this, and now it works fine
SELECT [STOCK].[ID], [STOCK].[PartNumber], [STOCK].[MFR], [STOCK].[QOH] FROM STOCK ORDER BY PartNumber;

And if you want to finetune so that all the part numbers that are the same are also secondarily sorted by manufacturer than perhaps add the extra field at the end of the SQL statement:
SELECT [STOCK].[ID], [STOCK].[PartNumber], [STOCK].[MFR], [STOCK].[QOH] FROM STOCK ORDER BY PartNumber, MFR;