I'm using the transfer database action and I want to transfer data to different databases at different times. What I would like to do is prompt the user for a part of the path in 'database name' how can I do this?

Do not trust the user to "key" in the location path. Make them point and click to find it.

Browse [Find a directory or file] (http://www.access-programmers.co.uk/forums/showthread.php?t=75790)

HTH