>>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

Use the NOFILTER clause with your select statement. For speed purposes, when it can, VFP dresses up a copy of the base table with a filter to give you your result set. The NOFILTER clause ensures that the result set has a real disk presence, instead of being the base table in disguise.

Erik Moore
Clientelligence