Hi Si,
OK. This form is for the configuration of a machine. There are 5 types of
machines, let's call them machines A through E. Each machine has a storage
unit that holds tools. There are 3 types of storage units, let's call them X,
Y, and Z. And there are 12 types of tools, let's call them 1 through 12.
Depending on the machine the storage unit and the type of tools used the
number of tools held will be different. In some cases there is a choice of
how many tools the storage unit will hold for a given machine type/tool type.
An example:
Machine A can hold 3 tools of tool type 1 in storage unit X, but can hold
either 5 or 10 tools of tool type 1 in storage unit Z.
Machine B can hold 7 tools of tool type 1 in storage unit X, but can hold
20 tools of tool type 4 in storage unit X.
etc., etc.,
So I need a drop down listbox that will display how many tools can be held
based on the machine type, magazine type and tool type.
I hope that clears it up a bit. If not, let me know.
Thanks again,
Jono
"Si" wrote:
[Quoted Text] > Hi Jono,
>
> Can you give a little more information on what you are trying to acheve
> and what the selection criteria is based on for the filtered list?
>
> Cheers,
>
> Si.
>
> Jono wrote:
> > Is it possible to have a list box who's list is dependent on selections made
> > in 3 other list boxes? I've used the instructions for creating a Cascading
> > List Box but this uses only one list box selection.
>
>
|