>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.
That explains it I think, you can see the correct way in Erik's reply. You're setting the recordsource to an empty string too late, it has to be done *before* the SQL into cursor...
The Anonymous Bureaucrat,
and frankly, quite content not to be
a member of either major US political party.