Timothy,
I just had the same problem as you (Cannot access the selected table). The simple cure is to set yourcombo.rowsource='' before doing select, and then reset it to your cursor.
Here is my sample code, which has another strange problem, I'm starting a new thread about:
.cmbRegions.rowsource=''
select towns.fullname, towns.Town , towns.ccode ;
from towns ;
where towns.Town = BldMstr.Town ;
union ;
select towns.fullname, PostRegn.joiningtwn as Town, towns.ccode ;
from PostRegn, towns ;
where PostRegn.joiningtwn = towns.Town and PostRegn.Town = BldMstr.Town ;
into cursor tRegion
.cmbRegions.rowsource='tRegion'
.cmbRegions.listindex=1
>>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
If it's not broken, fix it until it is.
My Blog