Requery? It sounded like a cursor to me. If it's cursor how did you create it?
Cetin
>The Form will open and display data. It is happening during a requery of the data source. Similar code works throughout this application with zero problems. I did have a problem at one point with losing my columns but that problem has been solved. This one has just started.
>
>Possibility of a corrupt Form file?
>
>Richard
>
>
>
>>>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
>>
>>Perhaps you're opening or creating your curDisplay in Form's Init, which is too late for the grid. You need to have curDisplay available in form's Load.