FileListbox DirListBox HELP

[akoymakoy]

how do i link my dirlistbox to the filelistbox viceversa...

I would like to use the path of the file selected in the filelistbox as a variable that i would use as a location for the DB that i will be using in my SELECT statement

this is what i would like to know:

Loc_variable = (the path of the file.db selected on the file listbox)

MyConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=loc_variable;"

instead of:

MyConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Thesis\testing\gary\test1.mdb;"

this is because the program that i am creating is something where i choose the .mdb file and it will be the chosen one will be the one i will use.

THANKS...