Thanks for your help, but Ian suggestion of blanking the RecordSource prior to the SELECT and resetting it afterward works very well.

>When you rebuild your cursor with another SQL the Grid loses it's .RecordSource. Consequently, everything below that is lost as well. I've never tried this suggestion before (the lightbulb came on while reading your post) so if you try this let me know how it works.
>
>1. Create a temporary table based on the cursor returned from your SQL-SELECT
>2. Base Grid.RecordSource on this table
>3. Run the SQL and APPEND all records to table.
>
>When you need to update info:
>
>1. ZAP table
>2. Run SQL
>3. Append to table