>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