Hi Guys,
Sorry to pop this question but I don't seem to be able to find the answer on-line. Lack of knowledge..
On my form I have a listbox125 that has a list of materials, it works well and contains different materials that are collected from table materials which contains material, buyprice, saleprice and category.
I would like to have this listbox list the category and when selected fold out to show the materials in that category and write the selected value to my table docket.
example;
Copper opens Element
Pipe
Tank
Steel opens Heavy
Light
Mixed
etc..
I looked at the cascading listboxes but could not make any sense of it in my situation, any help as always much appreciated..
Sorry to pop this question but I don't seem to be able to find the answer on-line. Lack of knowledge..

On my form I have a listbox125 that has a list of materials, it works well and contains different materials that are collected from table materials which contains material, buyprice, saleprice and category.
I would like to have this listbox list the category and when selected fold out to show the materials in that category and write the selected value to my table docket.
example;
Copper opens Element
Pipe
Tank
Steel opens Heavy
Light
Mixed
etc..
I looked at the cascading listboxes but could not make any sense of it in my situation, any help as always much appreciated..