Thank you. I am quite new at this, but after adding a column in a table for
the URLs, it worked OK. I thought I could just put something like "View
Letter" on the form, and make that a pointer directly to a document I have
in Word. It appears I must have a list of URLs in an Access table.
If there were 100 records, I would go through 100 occurrences of each form
when it displays each record. What I wanted was that when you clicked on
"View Letter", it would pull up the correct letter for that record. This
means a unique URL or file location for each Access record. It is slow to
enter the URLs in the table, but this is the only way I know how to make
this work.
- Phil
"Pieter Linden" <pi********@hotmail.com> wrote in message
news:bf**************************@posting.google.c om...
"Phil" <p.*****@comcast.net> wrote in message
news:<cpYCc.110491$HG.67523@attbi_s53>...
I am looking to set up a hyperlink control on a form to retrieve letters
that correspond to a record on a form. That is, there may be 100 form
records, and I would like each of those form records to have a hyperlink
button or control on it. that when pushed, pulls up the unique Word
document associated with that form record. In this example, there would 100
unique letters associated with 100 unique form records. I tried working with
this, but can not get the control to access UNIQUE letters. I am using Access
2000.
Thank you,
- Phil
So you have a field in your table that holds the path to the letter.
Then you just format that field in your form as a hyperlink. What do
you mean "unique" letters? You're getting the same one? Sounds like
you're putting a label or unbound field on your form instead of a
bound field.