PMFJI but try
SELECT ... FROM MESSAGE WHERE ...condition INTO CURSOR TEMP1 nofilter
Then do your use again.
HTH
Jeff
>>When the recordsource of a grid is an SQL statement, the result cursor is not available outside the grid. I recommend that you change the RecordSourceType back to alias, and then, in form.load, create the cursor with your SQL statement. YOu can then bind the textbox to the appropriate field in the cursor.
>
>That worked but the cursor is read only so I'm unable to modify the content of my textbox (which is bond to a memo field).
>I've tried the trick to have a writable cursor:
>
>SELECT ... FROM MESSAGE WHERE ...condition INTO CURSOR TEMP1
>if used('temp2')
> select temp2
> use in
>endif
>use dbf("temp1") in 0 again alias temp2
>
>but then, temp2 is a copy of MESSAGE table instead of TEMP1 ???
>
>What am I doing wrong?
>Claude
It's Time to get a gun.
That's what I've been thinkin.
I think I can afford one, If I do a little less Drinkin.www.TrueGeeks.com