Originally posted by Franky
I tried this before but it never worked with me, hehe

I have in a Form a rsWhatever.Sort and after this is done the sortorder should be correct. If I use .State as waiting-loop I never get the sortorder, but if i have after the .Sort command a line with an Msgbox then it works.

any ideas to that?

.... strange .....

nice greetings
Franky
Sort has nothing to do with DB activity; it is a function of the recordset object. Typically, it shouldn't return until it's done sorting.