>>>>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'
>>>
>>>Tim,
>>>Change your myListbox.Rowsourcetype to SQL and define SQL in its rowsource.
>>>
>>>

*myListbox4.init
>>>with this
>>> .Rowsourcetype = 4
>>> .Rowsource = 'select * from '+;
>>>  '(crsOffices.Office) into cursor whichoff'
>>>endwith
>>>
>>>*myListbox1.init
>>>with this
>>> .Rowsourcetype = 4
>>> .Rowsource = 'select ...,OfficeCursorName as Office from '+;
>>>  '... into cursor crsOffices'
>>>endwith
>>>*Valid
>>>with thisform.myListbox4
>>> .requery
>>> .listndex=0
>>>endwith
>>Cetin, I would like to try this but is this line gramatically correct?
>>{.Rowsource = 'select ...,OfficeCursorName as Office from '+;
>>>  '... into cursor crsOffices'}

>
>No Tim,
>I just left it as a skeleton to show where does (crsOffices.Office) come from. If you also use SQL for myListBox1 with a field Office as selection done you could directly get it with crsOffices.Office (w/o querying if myListbox1.Selected(1) ... )
>I can't be more specific w/o knowing how myListbox1 is populated.

I see.


>Cetin