Link to network folder from access form

[recon2011]

I have a form called clients that lists all of the projects associated with that client over the past several years. I also have a file on the network called Clients (Access is on the same network) with sub-folders in all of the clients' names. The client names are the same in my Access program as the network file. I need to create a link on the Client form that opens the folder on the network that corresponds to the same client name as the form. I can easily create a hyperlink to the Client folder on the network and from there I can scroll to the client name and open that folder. However, I would like the link to go directly to the client name in the Client folder (on the network). Is there a way to pull the client name from the Client form control that could be used to insert into a network address or something similar?



Example: the folder on the network is:

x://data/files/clients

This takes me to the folder that holds the sub-folders that are labeled by client name. If I want to go to the client folder named "XYZ Company" on the network I would open the client folder and scroll down to XYZ Company and open that folder (or click the shortcut).

The actual address for XYZ Company on the network would be:

x://data/files/clients/XYZ Company

Is there a way to insert the name from the Client control into the network address or another way to do this?

I apologize if I am over-explaining but I wanted to make sure I was clear in order to avoid clarifications. Thanks in advance.

[ranman256]

The "vProgram" can be file explorer, or iExplorer.
usu. "C:\Program Files\Internet Explorer\iexplore.exe "

vDir = x:\\data\files\clients\" & cboClient
call shell(vProgram & " " & vDir,vbMaximizedFocus )