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.
A problem is a problem only as long as it has a possible solution. Lacking that, it becomes a FACT!