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

You're getting back a filtered view - try adding the NOFILTER clause to your SQL Select statement.

>Claude

EMail: EdR@edrauh.com
"See, the sun is going down..."
"No, the horizon is moving up!"
 - Firesign Theater

NT and Win2K FAQ .. cWashington WSH/ADSI/WMI site
MS WSH site ........... WSH FAQ Site
Wrox Press .............. Win32 Scripting Journal
eSolutions Services, LLC

The Surgeon General has determined that prolonged exposure to the Windows Script Host may be addictive to laboratory mice and codemonkeys