David

Oops, sorry, referred to you by your surname, and then mis-spelled it. I'd just been at the Foxforum where the names are presented the other way round. Glad you've cracked it. Views is good!

Terry

>Hi Terry,
>
>I decided to try using views instead of creating cursors, and the problem disappeared.
>
>Although, there is definitely some kind of VFP conflict/bug when creating cursors within a private data session, which somehow loses the cursor's data (either through filtering it or overwriting it for some reason). I kept receiving a message that the filter was cleared, which wasn't from any action of mine. The strange thing is that this problem did not occur in the default data session setting.
>
>Dave
>
>>Robin
>>
>>Seems a bit strange. Have you tried selecting into a reuseable table instead? The table could be zapped beforehand or, if you open it with the form, and safety is off, its contents will be overwritten anyway with the new select.
>>
>>Terry