Link to a folder based on an autonumber

[Tdahlman]

I have a form that will automatically assign a Project Number (autonumber).
Within that form I want to have a link that will open a folder on my network
that is titled the same as my project number.
For example:
The project number is 1001.
I want to hit a button that will Go to W:\Projects\1001
However if the project number that I'm showing is 3037 then I want
W:\Projects\3037

Can someone please let me know if this is possible and if so, how to go
about it.

Thanks in advance.
Travis

 

[KARL DEWEY]

UNTESTED ----
Add a field, datatype Hyperlink to your table. Create a macro or event on
change of Project Number to Set Value of the hyperlink field.

 

[Lars Brownie]

Travis,

I think you're better off not storing the value in a hyperlink field and
creating the link and, if necessary, the directory on the fly.

See this thread
http://www.archivum.info/microsoft.public.access/2008-05/msg01470.html where
OP asks the exact same question.

Lars