Where is it not sorting correctly?
A Form, a Report, a Control like a dropdown?
If you run this as just a Query in the editor is it correct?

Does it appear to be sorting in an particular order?

Remember a sort in a report or a form will override the underlying query

Hello Richard and Alex

I thought I had said it was in a combo box not sorting properly as you can see I have it set to sort by in the product ID in the combo box but it seems to be sorting still alphabetically I have checked the table and it is correct as far as the items are in order that I wanted it to be but for some reason it is not displaying it correctly in the combo drop down this is after had it built and level 22 in the experts series

The order of the records in the table is meaningless. If that is indeed the SQL in the combo box then your data should sort by ID.

Hello Richard

It is being told to sort by product ID but it is not doing it as you will see in my original message I have order by product ID

If you save that query and an object in your db does it sort correctly?
Then could you try setting the Combo to that object instead of a SQL string.

I understand what you're saying. What I'm saying is that the SQL you wrote above is correct. That will sort by ProductID. However, something else AFTER that might be changing it. If you put a bunch of records in a table, they're not sorted. If you make a QUERY and then sort by ProductID, then your list will be sorted by ProductID. Now if you use that query in a COMBO BOX or a REPORT and you specify another sort in either of those, your list will now be sorted by THE LATEST CRITERIA. The combo box SQL or the report SQL will override the query settings.

Good morning Richard it is 3:30 am and I have found where the problem lies with this problem I'm having with the cascading combo boxes if I change the sort order in products in the product combo box it works correctly but as soon as I I selected an item in the categories the problem is back in the only way of getting it to resort is to close the database completely down and restart and go to the product combo box again and they sort is back the way I wanted by products please let me know when you're ready for more information and I will email you with more details of what order things should show up in

Michelle

Glad you figured it out.

Can you sort items in product table by product ID this was originally built in developer 6I do not want to sort it by product name as it does not keep it in the correct order in the combo box after selecting the category

I thought you'd got this working?
You mentioned Cascading Combo in the original title, which combo isn't sorting?
You select a Product and that filters a second combo with what items?

Hello Alex

Richard has been working on this it looks like what I was trying to do is not possible sorted by product ID well that's what Richard said and a private email today I just thought there may be another way around it by putting another column in or something to sort by which would keep their products in order

A QUERY should sort by the ORDER BY you have set, not knowing the full ins/outs I can only offer help with the info provided.
You could add a Sort column then use that in your ORDER BY but if the above isn't working I'm not sure why this column would over your other.

Do you have a simple example of what you are trying to do and what isn't working.

Hello Alex I can send you a link to a video in my one drive showing you what the problem is if you think that would help but I would prefer not to send it in the open forum but will if necessary then you would be able to have a look at the whole query I have got this was built with developer 6 listen 3I think

Any help you can give me would be gratefully appreciated and I need to get this up and running properly before having to payout a lot of money for a hip replacement

Unfortunately I don't have time to look at anything atm, maybe a fellow Developer could take a look if you post your question in the AccessDev.NET

Thank you Alex I had posted something on that website you pointed me towards just hope someone can help maybe with this problem thank you Michelle

I explained this to you in an email. All you have to do is change the RowSource property of the combo box so that it says "ORDER BY ProductID" instead of "ORDER BY ProductName".

Problem solved thank you Richard

You are very welcome.