General information
Category:
Forms & Form designer
Title:
Cannot access the selected table
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
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only