General information
Category:
Forms & Form designer
I am having trouble with a listbox.
The listbox is on page 2 of a pageframe. Page 1 contains a parent records. Page 2 contains a child record. (Each parent has 3 or 4 child records.) When you click on the page 2 tab, the Activate method does a SELECT statement to get an identifying field from the child table to populate the listbox.
At first I copied the records to an array for the listbox. Sometimes the listbox displayed all of the elements and sometimes not. When I got it to display all (I'm not sure how) I created an EXE file. When I ran the EXE from outside of VFP the listbox looked blank. I could click on it and the CLICK METHOD would execute for each element of the array, but the values of the array did not appear in the list box.
I then tried to display the values of the selected table in the listbox. When I go to records from page 1 and then click on page 2 in a particular sequence (this sequence includes going to a particular record based on choosing a particular value in a drop-down list on page 1, but I can choose the value in a different sequence and the error does not occur) I get the following error:
Cannot access the selected table (Error 1152)
You have attempted to select a table outside the 32K work area range or are attempting to reference a file variable in a table that is not open.
The error does not occur when I remove the offending listbox. I have about 100 variables mostly in arrays. If I put "=timeout(2)" as the first command in the Activate method, the error occurs EVERY TIME.
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