Strange sort order of records on a form.

[Miles R]

Can't figure out what is happening here. I have a form with a recordset based on a query. If I set the OrderBy (with OrderBY on load true) in design mode, the order of the records on the form is correct. However, I wanted to set the OrderBy in VBA. When I do this (and clear the value in design mode), it totally ignores the sort order I have just set (in the Form Open Event code). In fact the sort order it is using seems to be some saved sort order based on an older version of data in my table.
(i.e. I had two records in the wrong order, so I changed them, but the form was still sorting based on the records in the wrong order).
Hope this makes sense.
Put simply, does it work to set the OrderBy in VBA, or do you have to do something else as well?

[isladogs]

Now you've added more info, but you still haven't given us a clue what you are sorting by.
So I'm going to take a guess.
Are you sorting by a field with numbers that is actually a text field?
If so, it will sort in 'alphabetical order' e.g. 1,10,11,12,13,2,23,25,3,4

If that's not it...please can you at least tell us what the recordset is & show a screenshot of the sorted records

[June7]

Post your code or db for analysis.

Did you set OrderBy as well as OrderByOn properties?

Does work for me.

[Miles R]

Colin, no I was sorting by several fields, text and numbers.
However I think June7 has solved the problem. I did not set OrderBYOn. I did not see this property in the Design Mode, so missed it in the VBA.
Just tried this and it now works.
Will have to research Orderby properties a bit more. Am a bit rusty on Access, despite having used it for 15 years.
Thanks.

[Miles R]

Great thanks June, I had not set OrderByOn. It works now.

[isladogs]

Glad you have a solution.
If you use the OrderBy approach, you do need to exactly the same whether using vba or the property sheet