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