hyperlink with code

[ETID]

Anyone know how to create a hyperlink upon closing of a form, to a network file named for a field in that form?

I.E.

In my form I have a field named letter_number bound to a table called letters.

if the field is populated with "Jan_01_sales_mm01"

I want it to create a hyperlink in the table to "x:\Sales\Jan_01_sales_mm01.pdf"

...sound do able?

 

[scking]

It is considered bad manners to post the same question on multiple newsgroups. I believe your answer is in the Access Modules group. ----------------------
scking@arinc.com
Life is filled with lessons.
We are responsible for the
results of the quizzes.
-----------------------

 

[ETID]

Thanks for the lecture on manners.....but I was not sure which forum was best suited for this problem.