Ok. Here is the story.
I open my table
I index on every field in my table
I createobj("form")
I addobject("grid")
I set the record source
I loop thru the columns, removing header1 and adding myhead1
I define a custom click event in myhead1 that does a set order and a thisform.refresh.
I run the form. Everything looks swell... but then I click on header. The column gets resorted. Yeah! I click on another header, the grid gets sorted by that, Yeah!
But then I noticed that even if I have clicked on a row in the grid, when I click on the header, I end up on a random row. Why doesn't it stay on the same row? How can I predict what row its going to go to?
--Todd Sherman
-Wake Up! Smell the Coffee!