I'm writing the programm which looks for the folder in Database, then for subfolders of this folder, then subsubfolder.... I have three columns in table: id, parentid and name.
1) Find folder:
SQLQuery = ("SELECT id FROM table WHERE name=" & txtEnterName.Text & "'")
txtDataid.Text = id
2) When I receive ID I have to look in parentid colum whether this folder has subfolders:
SQLQuery1 = ("SELECT id FROM table WHERE parentid='" & txtDataid.Text & "'")
3) etc.....
Maybe someone has code with recursive function? Help!

P.S. Sorry, I must write English, because I don't have Russian keyboard, I don't know blind method and I hate "translit".