filling a listbox

[ronmon]

Okay heres my problem i have a listbox that is populated according to the selections made in another listbox now this works grand if i only select one value in the first listbox but as soon as i select a second value in the listbox the the second listbox is reset and only displays the information about the second selection. Is there a way to append these values on to the listbox?

 

[afryer]

Hi,

Easiest way I can think of is to have a table, which contains the values you want to display. Link your list box to this and then each time an item is selected from the first list box then insert the values into the table and refresh the second list box.

Andrew

 

[KenReay]

Hi

The short answer is yes, it is possible

But to get a more detailed answer about how to achive it we need to know how you are populating the list box, ie is it a query with a criteria of the second list box, is it a list of entries which you update...etc

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[ronmon]

currently i am populating the second listbox by alterinjg the Listbox.Recordsource in VBA and then requery it