I have a database in which I am storing information and assigning a ID
number to each entry. From those entries, a report is generated and
saved to a designated directory on my server. I would like to somehow
automatically assign a hyperlink to that forms ID number in the
database so that anyone can simply click on the hyperlink and pull up
the form.

Basically I need to do a find last row command and place the hyperlink
in the ID number cell. The hyperlinks will always go to the same
directory, but the variable would obviously be the form ID number.

Is there a way to do this or even if I have to place a hyperlink in
each cell using a directory reference from another cell would work,
but I am having trouble with the variable working.

Thanks for any advice,
Brad


--
Brad J.
------------------------------------------------------------------------
Brad J.'s Profile: http://www.excelforum.com/member.php...o&userid=21713
View this thread: http://www.excelforum.com/showthread...hreadid=555180