>> 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.