directory dialog

[Guest]

How do I prompt the user to specify a directory when entering data into
forms? I know how the FileDialog works....but I only want to create a
variable storing the directory the user chooses. The file name itself is a
built string from other data the user enters, and the path is not dynamic.
Any suggestions? i.e. the field with the filepath is accessing existing files
in a folder, however if the user moves the files to a different location,
they'd have to go into the code to change the directory all of the files are
stored in.

Thanks

 

[Allen Browne]

See:
Call Windows Browse for Folder Dialog box
at:
http://www.mvps.org/access/api/api0002.htm

 

[Guest]

Nevermind.....I found some code by Terry Kreft which works fabulously!

http://www.mvps.org/access/api/api0002.htm

cheers

 

[Guest]

Thanks Allen....I managed to find that code myself......