I think, we have the similar problem recently in one of my colleague application. I'll check it and let you know, if I find something...



>>Are you sure, all offices tables are open now? Switch to command window and type set to check, what you have all them opened.
>>
>>>I have gotten this message before "CANNOT ACCESS SELECTED TABLE" and unfortunately, it doesn't generate an error so it's hard to debug. But I now get it during the interactive change of listbox1:
>>>If thisform.mylistbox1.selected(1)=.t.
>>>select * from office2 into cursor whichoff
>>>endi
>>>If thisform.mylistbox1.selected(2)=.t.
>>>select * from office1 into cursor whichoff
>>>endi
>>>If thisform.mylistbox1.selected(3)=.t.
>>>select * from office0 into cursor whichoff
>>>endi
>>>If thisform.mylistbox1.selected(4)=.t.
>>>select * from office9 into cursor whichoff
>>>endi
>>>
>>>thisform.mylistbox4.rowsource='whichoff'
>
>Hi Nadya, this is like a problem revisited. The set reveals:
>whichoff
>office9
>office0
>office2
>office1