Linked List Box with Unique Values

[E_DPSG]

Good morning all -

I have been working over the weekend to think of a way to make this work. Unfortunately, either my brain went dead with all the upsets in college football or I am too tired to focus, I cannot make this work.

What I have is a list of Vendors that contains A Vendor ID, Vendor Name, Vendor State, Vendor Region, and Vendor Division. Please note that the order of this information can be changed - but is coming out of Access.

What I need to do is filter down to a unique list of Vendor ID's (or Name) based on the previous 3 filters (A total of 4 drop down boxes).

Filter would be: Division as primary, Region 2nd, State third, and finally the vendor.

Can anyone point me in the right direction? I would imagine that the formula to ping off the first can carry over to the 3rd and 4th drop down. Oh, I am running Excel 2003 and Access 2003 - still trying to convince IT of the need to get an upgrade.

Thanks in advance for your help!

 

[E_DPSG]

Two things:

1. This was actually a ComboBox.

2. I used a DAO connection and wrote queries to return the values on change vent for each of the boxes.

The last step I have to do is dynamically define the ranges for each of the lookups. This will not be too difficult.

I suppose if anyone wants the solution code, you can post a reply requesting it. seems to be a lack in responses on the board of late.