Pop up second listbox when certain criteria met

On my form I have a listbox that I have linked to my suppliers table in my sql database. I want to create a second listbox (linked to another table - supplierlocations) that will pop up beside the first if a user clicks on a supplier that has more than one location/branch. Sort of like when you click on all programs on the computer and the additional programs pop up out the side to be selected.

I can create the listbox etc and bind it, I will probably use the visible property to have it appear when required, but what Im not sure about is how do I code the items (suppliers) in the first listbox (listbox1) to look through the second table (supplierlocations) and if the supplier has more than one location open the second listbox for the user to make their selection.

Thanks for any help on this, Diane

Not quite, sorry im not too good at explaining things.

Listbox 1 Supplier 1 (Pop up listbox only if that supplier has more than one branch) Branch 1, Branch 2

Supplier 2

Supplier 3

Need to be able to select the suppliers branch, since im doing a program for our transport company I need to be able to get to exactly the right branch that the load is being picked up from. I will be doing the same type of thing for the customers.

Diane

Yes, you've got it, doesn't necessarily neet to be on a seperate form, could be a panel, or just the listbox itself.

Diane