Good afternoon. I am new to programming of any sort. I was recently asked to develop a database to track member records. As I've figured it out I've been requested to make changes but this 1 had ne stumped. My db has records for 300 members. Each member has a folder on the share drive that contains multiple documents that we have to maintain. The higher ups would like a button on the form that opens that members folders. I I have renamed all the folders to have the same format
Lastname, firstname organization
I was able to open the parent folder with the button, but have not been able to determine how to add this last branch via vba.
Dim member
Member = [last name] & ", "& [first name] & " " & [org]
I've tried adding "member" and [member] to the end of file path but no avail.
S:/command/parentfolder/"member"
It hasnt worked. How can I add that specific information without having to create 300+ code lines?
Thank you for any assistance you all can provide.