Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Paul Brown
  
 York
 
 Paul Brown
 To: Edgar Salcedo
  Where is Edgar Salcedo?
 Bogotá
 Colombia
 Edgar Salcedo
 Tags
Subject: RE: Error:Cannot access the selected table
Thread ID: 21898 Message ID: 21915 # Views: 24 # Ratings: 0
Version: Visual FoxPro 6 Category: General VFP Topics
Date: Friday, April 04, 2003 11:56:52 AM         
   


Hi

You have used a query as the source for a combo. My base class combo uses an array for the source and there are never any problems.

In your base combo add an array property aItems[1]
Set the RowSource to This.aItems and the type to 5 (array)

In your form...
In the combo Init or other setup method..

Do the SQL e.g.

SELECT * FROM YourTable INTO ARRAY This.aItems
This.Requery()

Set the ControlSource, BoundTo and BoundColumn properties and you're done.
HTH
Paul

COMPLETE THREAD

Error:Cannot access the selected table Posted by Edgar Salcedo @ 4/3/2003 10:08:59 PM
RE: Error:Cannot access the selected table Posted by Paul Brown @ 4/4/2003 11:56:52 AM