Hello! Thank you for your assistance. I apologize for the long post but I want to make sure it's detailed.
On my Documents form, would it be possible to have a text box where the user enters an order #, clicks a command button and displays the directory (which is the order #) in a listbox?
Currently, the Main form creates a folder on the computer with the same name as the order # (ID) when a new record is created. For example, if the new order # is 100, the database will create a new folder called 100 after the record is inserted.
So, once the record and the folder are created, the user will open the Documents form to view documents that are available, enter the order # in a text box, and click a command button. After the command button is clicked, the listbox should pull up the directory based on what the user entered in the text box.
If the user enters order # (ID) 100 in the textbox, Access will look for directory c:\RealEstate\100 and populate the lisbox with the contents of directory c:\RealEstate\100.
I appreciate your assistance and hope this post makes sense.