Create a way to load files from a collection of references

I have a a form which collects a path, this is taken into a table and duplicated for each row but also in addition it concats a string which is hard coded with a counrer

so a user enters

z://mydocuments

the table with VBA then loops through all the folders in mydocuments and logs these with the hard coded string called "/source" + intcounter

so we get z:/mydocuments/source1, z:/mydocuments/source2 and so on, this works perfact and is fine.

The second part will pick up a file from each folder then run procedures to load the files from all the folders to the database via other routines. However this is fine when it happens to be the first folder by it doesnt do this for the second record in the log of all the folders. I feel in the loop something needs to be initialized before it can go back and run the sub routines on the second record and so forth.
Where am i going wrong?
there is a view loops which do this loadng and its this which i feel is not working correctly.

Can i send you the code to show this?