>When the SQL stmt executes the record content is correct. Let me say this, when I change the into clause from cursor to table everything works. Heres the arrangement:
>
>Valid clause of field-- execute sql into cursor (works right)
>Click of Button -- make page 2 active (the cursor already exists)
> grid.recordsource=''
> grid.refresh()
> grid.recordsource='thecursor'
> grid.refresh() (now has all records of base table+generates an error that one of the having paramaters of the sql statement is not found which indicates to me that it is attemting to reexecute the sql statement)
>
>There is an additional and prior field and button that do the same thing but with a table (the user can delete records he does not want to be part of the process) which works fine.

Have you tried NOFILTER in the SQL statement?

You are still missing the time when it is important to clear the grid's recordsource; you need to do this BEFORE the SQL statement that creates it's source runs. The reason this is usually important is because when you recreate a grid's recordsource while it is bound, it temporarily destroys the source, the grid "senses" this, panics, and forgets all of its settings. By clearing its recordource first, you are "shielding its eyes" from the destruction of its beloved cursor.