"Beserk" in what sense? a change in the SELECT ORDER not expected to affect the grid.
That is what I also thought. Any change I make into ANY of the segments in SELECT, ORDER, WHERE will result in my grid going beserk.
A little googling made me find this (which works like a charm):
* previous to this, create a temp cursor with the same structure as the CA cursors in INIT of form and build up your gridThisForm.myGrid.RecordSource = "myTempCursor"
myCursor.CursorFill()
ThisForm.myGrid.RecordSource = "myCursor"