Interdependent Comboboxes

[ejbaumann15]

Hello everyone, I have a question. I am creating a tool list in Access where tools can be checked in and out by employees. I have a table that is the master tool list containing all tools. The table columns are Tool Type (three options: Drill, End Mill, Ball End Mill), supplier, brand, number of flutes, cutting diameter, shank diameter, flute length, and overall length.

I have a Checkout Tools form containing a combobox that will correspond to each of the above columns. What ive been trying to do is make these comboboxes interdependent. When the form is opened the first time each combobox list contains every option for each catagory with no duplicates. I need the user to be able to change the value for any combobox whether its the first or last and have the rest of the comboboxes lists change depending on the selection. I'm trying to make it so that by the time the user enters the all the information there is only one option left and they can check out that specific tool.



Is there any way I can do this? Ive been reading about cascading comboboxes but i cant find any examples where there is more than 2 comboboxes, and it seems that you have to input information in a certain order which i cant have.

[June7]

I don't think what you want is practical. I've worked with this scenario before and it just fails miserably.

Can have any number of dependent controls but AFAIK, must be hierarchical.

[ejbaumann15]

So if I made it hierarchical how would I go about that? The information that is most important is the Tool type, Number of Flutes, Cutting Diameter, Shank Diameter, Flute Length, and Overall Length. If I had them input this information in that order is it possible to filter down the lists of the comboboxes?

[June7]

Maybe, but I don't know your data structure enough to answer that for sure.

[ejbaumann15]

Hi June, I appreciate the replies. I originally started this project all in Microsoft Excel. I've been working on it for a long time and couldn't figure out this issue in Excel so I moved to Access thinking it might be slightly easier, I was wrong. I finally figured it out on microsoft excel in vba, I can post the code I don't know if you're interested or not but it works exactly how I described above. It's all in vba and I'm sure could be used in Access to, just would have to change around a few things.

[June7]

Post the code if you want. Someone else might find it useful.