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'
If it's not broken, fix it until it is.
My Blog