>This error is driving me nuts. Here is my code:
>
>select ship_order+'-'+suffix as so,client_id,card_type,card_id,; no_carrier+no_conlys as no_cards,short_name,csr,recd_date,due_date;
> from otrack;
> where &lcstat&mywhere order by &myorder into cursor tmpopen
>thisform.list1.columncount = 9
>thisform.list1.columnwidths = "60,65,20,55,40,200,25,60,60"
>thisform.list1.rowsourcetype = 2 &&alias
>thisform.list1.rowsource = 'tmpopen'
>thisform.list1.requery
>
>When the .rowsource = 'tmpopen' runs I get the CANNOT ACCESS SELECTED TABLE error message. I've tried adding NOFILTER but it did not help. Also, I can't use rowsourcetype = SQL because the statement gets larger than 255 characters at times. This code is in a form method I created and is called from several different places but the error message only occurs after being called from the click event of one commandbutton. If I break just before the .rowsource line I can access the table througth the command window etc. Please help if you can.
>
>thanks,
>dave


I've seen that error when the table/cursor gets closed unexpectedly.