You could use the Dir() Function to return the folder name, using a combination of known paths and wildcards and specifying the vbDirectory attribute. See the Access VBA help menu (from the VBIDE window) and search for "Dir"