>Thanks Marcia.
>
>I do have you excellent book "1001..." as well as MegaFox. Guess I was trying to avoid having to set the RS to a cursor and have to fill it from the output of a SQL statement, but it turned out the be the right solution, as you already know.

"right solution" is relative. There are many who don't want to run an SQL statement to produce a cursor in the first place, as it takes time. They prefer to use SET FILTER/SEEK/SET KEY etc as it manipulates the data directly. Having to run another mass move of the data via the ZAP and APPEND from must seem ridiculous to them.

I think I take the middle road. Find a way to safely reconnect the grid to the updated record source. It's what MaxFrame does. It works when the result set is small or large. The "safe select" approach will bog down - twice - as more records meet the user's criteria.