Information générale
Catégorie:
Gestionnaire d'écran & Écrans
Titre:
Cannot access selected table
My class-based form has pages with a list-box on each one. I populate those listboxes with the results of a SELECT. This displays just fine initially. Also, I populate a listbox outside of the pageframe with the results of a SELECT, a dataset from several tables, including the one just created for the afore-mentioned listbox. (I'm sorry, I write fiction, hence the verbosity). The error message appears, and the listbox disappears from the page... neither table created by the SELECTs is not at EOF(). Why do I get a 'Cannot access selected table' and see the listbox disappear? Properties for the shy and prematurely retiring listbox are:
BoundColumn=2 (text field)
ColumnCount=2
DisplayValue=(None)
RowSource=ABC.PatName,PIDCode
RowSourceType=6 - Fields
TablIndex=1
The rest are height and width and location goodies. The InterActiveChange event has the following:
LOCAL cCurrCode
SELECT Patient_
LOCATE FOR PIDCode = ABC.PIDCode
cCurrCode = PIDCode
SELECT ABC
WITH THISFORM
.MakeLists("ABC",cCurrCode)
.pgf.page1.TxtPIDCode.REFRESH()
.pgf.page1.TxtSex.REFRESH()
.LstProcs.REQUERY()
ENDWITH
Anyone?
TIA, Robin
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement