Hi Richard,

If you re-create your grid cursor, you should do

thisform.grid.RecordSource = ""
select ...
thisform.grid.RecordSource = 'curDisplay'

The recommended method, though, is to have a permanent cursor for the grid, select into another temp cursor, zap the original and append from temp cursor.

>curDisplay IS the selected workarea/alias and open. Verified with MESSAGEBOX(ALIAS(SELECT(0))). Prior to the problematic line.
>
>The curDisplay is created immediately before the SELECT curDisplay line. Using a Select-SQL.
>
>
>
>>>This particular error is bothering me.
>>>
>>>On this one line:
>>>

>>> Grid1.RecordSource = 'curDisplay'
>>>

>>>
>>>VFP 9 Runtime reports an error of : "No table is open in the current work area"
>>>
>>>However, (I have my executable spit out a file with tables in use etc) I can plainly see the table in use in the current Datasession:
>>>

>>>...
>>>Alias			Table File
>>>CURDISPLAY		00003QXL004H.TMP
>>>...
>>>

>>>
>>>I have placed this line before the line giving an error to ensure it is there:
>>>

>>>SELECT curDisplay
>>>

>>>
>>>I even have it verifying that it is in use PRIOR to the statement giving the error. What gives?
>>>
>>>Any ideas would be appreciated.
>>>
>>>Richard
>>
>>Richard,
>>It is not saying 'curDisplay' is not found, it's saying no table is open in current workarea. What is the alias() in current workarea, check that. Probably curDisplay was created with afields().
>>Cetin