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