>> Also, in a CA you can tweak the where clause at will (just preserve your original statement for later) and just requery()
>If memory serves requery won't do - you need CursorFill()

Change the corresponding .*command property before the requery. The trouble with .CursorFill() is that it recreates the cursor, which kills the grid. Requery() doesn't.

>The only downside I have found this far is that I couldn't get it to work with views, only tables

Haven't really tried. Perhaps someone who did will join this thread.