First off I want to say thanks for your replies thus far.
No, I did'nt try your code, I read it and tried to make sense of it though.
If you don't mind I'd like to spell out what I'm trying to achieve.
On our network drive employees must keep their project files in 2 different folders. These 2 folders are either "Working" or "FairCost". IE; either the project is active or complete. We then have 4 different types of projects. These are based on the customer asking us to do their project.
So, the path where they are to keep the files arent set to just one location.
Right now, the employee navigates to the drive and creates a UPC folder under Y:\Working\ then whichever of the 4 types of customer\then the UPC
Then they have to make between 2 & 10 other folders within the UPC folder.
Only the employee knows which ones he/she would need to create as far as sub folders. As you can imagine this takes time to preform each time a new project starts. And we also have employees who don't understand how to do this. They put their files in the wrong folders ect...
So, when I came across a post that suggested making folders on the fly was easy and possible, it put a big smile on my face thinking how this would make life so much easier for all!
To be honest, I did'nt think I'd be able to provide this with my limited knowledge of writing code. After spending many hours I finally was able to produce the sample db I posted here for further help. My current code is very long. Yours is much smaller, I just don't know how to incorporate it into my needs.
I could stop where I am and call it good enough to be able to atleast create the UPC folder and place it in the correct location, and tell the employees they would still need to make thier own sub folders.
Now, one question is: is the code I posted a bad starting point and or worthless in order to also make sub folders? I don't know.... What is certain is, if I go any further I will need more than a nudge in the right direction....especially since I want the employee to select from check boxes on the form which ones they need...