please help

[Paul]

Hi!
I have a report which includes a subreport. The main
report contains information for manholes that require a
repair which has not been completed. This information is
being pulled from a query that determines which repairs
haven't been completed. My problem comes with the
subreport. The subreport pulls information from a table
that contains links to pictures of the manhole before the
repair is completed. The information is linked by the
manhole number. I can pull the link into the report, but
it only displays the file name and location as text, as
opposed to displaying it as a hyperlink. I have "Is
Hyperlink" set to "yes". Can anyone please help me? Thanks
a bunch in advance!!

 

[Duane Hookom]

I would place an image control on the subreport. Then in the On Format event
of the section containing the control, use code like:
Me.imgMyControl.Picture = Me.txtFileName