B
bejewell
Please forgive me if this is an obvious question...
My database houses a list of files and their locations on our company's
network. My master query includes the file name, the file's current
location, and its old location, among other things.
I have created a form that allows the user to search the master list for
locations (really network folders) containing his/her specified criteria.
Several of these folders have similar names ("Environmental Justice",
"Environmental Tracking", "Environmental Management", etc.), so if the user
enters the word "Environmental" as his/her criteria, the search results
include items in all of these folders.
I would like the results of the search to display so that all of the folders
meeting the criteria appear in a list box, allowing the user to select the
specific folder he/she is looking for and pull up a list of only the files
inside that folder.
Is this possible? It must be! I just haven't had any luck figuring out how
to make it happen. Perhaps the answer is staring me right in the face but
I'm missing it?
Any help would be greatly appreciated...Thanks so much!!
My database houses a list of files and their locations on our company's
network. My master query includes the file name, the file's current
location, and its old location, among other things.
I have created a form that allows the user to search the master list for
locations (really network folders) containing his/her specified criteria.
Several of these folders have similar names ("Environmental Justice",
"Environmental Tracking", "Environmental Management", etc.), so if the user
enters the word "Environmental" as his/her criteria, the search results
include items in all of these folders.
I would like the results of the search to display so that all of the folders
meeting the criteria appear in a list box, allowing the user to select the
specific folder he/she is looking for and pull up a list of only the files
inside that folder.
Is this possible? It must be! I just haven't had any luck figuring out how
to make it happen. Perhaps the answer is staring me right in the face but
I'm missing it?
Any help would be greatly appreciated...Thanks so much!!