I have code in place that has a user click a button and a select file
location would be entered in a filed named txtLocation based on the selected
record.

The final line of code I have is:
Me.txtLocation = strInputFileName

This works fine but it enters: Z:\FileLlocation\ABC\FileName.PDF

Instead if it entering Z:\FileLocation\ABC in the field, I would like it to
begin with \\ServerName\Filelocation\ABC

Basically, instead of it displaying the location based on the mapping on my
screen, I would like it formatted based on the server location.

BZeyger,

Suggestion, I store the UNC path in a table and then use it to 'put
together' my file path. SInce the Server Name rarely, if ever, changes no
need to worry about maintenance.

--
Gina Whipp

"I feel I have been denied critical, need to know, information!" - Tremors
II

http://www.regina-whipp.com/index_files/TipList.htm

"BZeyger" <(E-Mail Removed)> wrote in message
news:60460D9E-09D2-4747-A59F-(E-Mail Removed)...
>I have code in place that has a user click a button and a select file
> location would be entered in a filed named txtLocation based on the
> selected
> record.
>
> The final line of code I have is:
> Me.txtLocation = strInputFileName
>
> This works fine but it enters: Z:\FileLlocation\ABC\FileName.PDF
>
> Instead if it entering Z:\FileLocation\ABC in the field, I would like it
> to
> begin with \\ServerName\Filelocation\ABC
>
> Basically, instead of it displaying the location based on the mapping on
> my
> screen, I would like it formatted based on the server location.
>