Browse and Store fileaname

[Bob]

Greetings!

I need to use the windows browse dialog to select and store a
fileaname.

I can get the filename with the path no problem. But I ONLY want to
return the filename.

Does anyone know how I can just return the filename?

Thanks!

Bob

[Allen Browne]

You can parse the file name from the fully qualified path with InstrRev()
and Mid().

Alternatively, Dir() around the fully qualified path will return the file
name.

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Bob" <st***********@hotmail.com> wrote in message
news:11**********************@f14g2000cwb.googlegr oups.com...

Greetings!

I need to use the windows browse dialog to select and store a
fileaname.

I can get the filename with the path no problem. But I ONLY want to
return the filename.

Does anyone know how I can just return the filename?