ListBox1 populates Listbox2 upon selection from a sheet?

[davedave24]

Hi. I have 2 listboxes, and several textboxes.

listCustomer holds the list of customers;
listRefNo holds the list of reference numbers attached to the customers;
the various textboxes hold all the data from the corresponding record in excel (date, amount and so on, not important).

Each customer may have more than 1 record/ref number attached to their name.

Excel is setup with Customers in column A, Ref No in column B, and the various pieces of data in C, D, E and so on.

When I click the customer's name in listCustomer, I need listRefNo to populate with only that selected customer's reference numbers. Then, when the user clicks one of those reference numbers, the textboxes fill with the various data from the other columns in the same row as that reference number.

I've been searching the forums for a solution but there are a lot of topics on listboxes and I'm dredging through them, so I apologise if it's been asked before and I haven't seen it.

Thanks guys.

 

[SkipVought]

hi,

Do this often.

Use MS Query to return the resultset for the selected customer. Point your second listbox to the resultset from the query.

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[davedave24]

Do you have any exampls of this?

 

[PHV]

Have a look here:
faq68-5829

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886