combobox based on folder names

[sdel_nevo]

Hi guys

sorry if this has been asked before
i am really strugling with doing the following, what i need to do is this,

i have a form called "form1" and on this form i have 3 comboboxes "customercbo", "ProcessCBO" and "filescbo"

i need to ba able to populate the combobox "customerscbo" from the folder names in a directory on our network, in this case i:\data\testsheets\customers

in each customers folder we have varuois processes for example "process 1", "process 2", "process 3" this is were i need to get the values for the ProcessCBO from

in each process folder we then have documents held as pdf files, these files i will need to have listed in the combobox called "filescbo"

finaly when all three combo boxes have the relivent information in i will click a button called "print" that will print the pdf document



any help would be great as im starting to get really stuck with how to do this

Steve

[June7]

Maybe this will help http://www.allenbrowne.com/ser-59.html

[ssanfu]

Maybe this will help you:

DirListBox() function
http://www.allenbrowne.com/func-02.html

You (I would) will have to create two more functions (based on the above function) for the "ProcessCBO" and "filescbo" combo boxes.

[sdel_nevo]

Hi guys

Many thanks for the pointers, I will have a go at this when I get into the office in the morning and let you know how I get on.