Hi,
>For instance, the indeces are created well, no problem with that, but SET ORDER never takes effect on my grid, I have used .refresh(), requery() and
>the view never 'reorders' itself.
Well, usually there should not be a problem with that. Is the RowSource for your grid the alias of the view or did you put the name of the original table in inadvertently?
>Another weird thing that happended is that every time I open the
>form the view remains ordered with an old expression of and index that i deleted from code hours ago and the new defined index never takes effect in the view.
>What could be wrong?
Could be the same cause as described above.
HTH,
Armin