Open a directory pending on a field in a form

[snuffi01]

I have read many threads regarding somwhere near my issue, but i dont get it to work and dont know if i overwork it.

I have an form where a field containes CompanyName, i also have an button witch should open a directory where all (for example offerts is of the specific customer).
The path is Y:\Sync mot server\Kunder\"CompanyName"\Förbindningstabell/

I want the button to open the directory Y:\Sync mot server\Kunder\Ericsson\Förbindningstabell/ when i am in the form of my customer ericsson.

Please help me!

 

[hermanlaksko]

Try this:

The path is Y:\Sync mot server\Kunder\" & me!CompanyName & "\Förbindningstabell/

Rgds
Herman

 

[snuffi01]

Thanks for the ansver!
But it doesn't work.
It works untill i put in the \" & me!CompanyName & "Then it doesn't work anymore!

 

[Rolliee]

Try hanging a CH(34) & on the front of the path and a & ch(34) on the end. To be sure make the path a string and look at the string using msgbox. It will probably tell you what you are doing wrong.

rollie@bwsys.net

 

[hermanlaksko]

The: "Y:\Sync mot server\Kunder\" & CompanyName & "\Förbindningstabell\"

Works fine here, however note that I have changed your "\Förbindningstabell/" to "\Förbindningstabell\"
Rgds
Herman

 

[snuffi01]

Thanks now i got it to work.
When i tried with an hyperlink i didn't get it to work, but when i tried with an button and Application.FollowHyperlink then it worked just fine.