>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