Get file name from listbox selection.

[Homegrownandy]

I do actually need help on this one. I've exhausted evything I can think of.

I'm using this code:
http://www.utteraccess.com/forum/Pop...-t1209291.html

I want to leave it exactly as it is. When the user double clicks a template it will open for them to review.
But, what I want is just the file name thats highlighted so I can use it as a variable in other code.

(including the file extension.)



I can then simply add this to the file path and run my other code on it.

Would really appreciate the help.

Thanks, Andy.

[isladogs]

I would suggest you don't leave it as it is.
To my mind that's a very badly designed listbox with one column containing file name with no extension, file purpose and date each separated by _____
It's also hard coded to root of C:\ drive

Much better to have 3 separate columns, include the extension and a button that opens a folder dialog to select a folder.
Better still do the same as a continuous or datasheet subform

[orange]

You my also get some ideas from Allen Browne's article on Listing Directories and http://allenbrowne.com/ser-59.html
I agree with Colin, the display is confusing and is dealing at root level.

[Homegrownandy]

appreciate the replies, looks like I have some more work to do.

[Homegrownandy]

Much better and easy to understand. Thanks both for the sugestions.