General information
Category:
Forms & Form designer
Title:
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
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