>I have a grid displaying data of a cursor. The initialy empty cursor is created when i issue a SQLEXEC() in the Load event of my form with a whereclause that will never select any records.
>When i reissue my SQLEXEC(), but this time with data my grid looses its member-objects and its recordsource.
>This is probably because the cursor is closed and recreated when i reissue a SQLEXEC().
>
>Does anybody know the 'workaround' for this problem?
>
>Marco Beuk.
lcoldsource = this.recordsource
this.recordsource=''
change your table
this.recordsource=lcoldsource
* Human is a question asked by birth and answered by death. Machine is another kind of question with another kind of answer