Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Display values in 2nd listbox based on a value 1st listb
Message
From
16/04/2007 13:19:07
 
 
To
16/04/2007 12:46:44
General information
Forum:
Visual FoxPro
Category:
Forms & Form designer
Miscellaneous
Thread ID:
01216304
Message ID:
01216361
Views:
20
>Do you mean the interactive change event of list box A?
>
>What properties should list box B have?

It depends how many items will be there. Most likely, it should be rowsourcetype=0, and columncount=[how many fields you want to show]; and you will populate it using AddListItem method.

>
>>>I would like to display values in a second list box based on a value in the first list box. For example suppose that list box A contains the values
>>>
>>>a b
>>>c d
>>>e f
>>>etc
>>>
from table data1. Then if I click on a line in list box A I want list box B to show the files
>>>
>>>h i j
>>>k l m
>>>n o p
>>>etc
>>>
from table data2 where the triplets are based on the values a, b, c etc (i,e field data2.field = data1.field where field is a, b, c, etc. Is this possible if so.
>>
>>You should place your code querying table 'data2' to ListboxA.InteractiveChange event.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform