image linking...

[dodgyone]

I'm linking an image into the report by using a field to enter the file name into and then the following to pull the image into the report:

Me!Image14.Picture = "\\IDCNT2\NetVisual$\" & [PhotoRefNo] & ".jpg"

This code is being used on report_open and report_activate. The first image is not shown using only report_open so both have to be used (any ideas here as well?).

The problem is if I scroll through the records by typing in a page number then the images go all astray and are not displayed on the right pages. The report has been set-up to display only one image and the associated records on each page.

Is this making sense at all... thanks...

 

[dodgyone]

Has anyone any ideas why the photographs linked into the report do not collate with the record information on the page?
Using the navigation button on the report preview I can go to the very last sheet and the image is from the second page even though the code says to use the photo reference number for that record on the image...


Many thanks...

 

[dodgyone]

Problem solved if you want the answer as follows:

Go to the report detail property and use the event "Detail_Print" to place the code into. THena ll is well.

The code to yse by the way is:

Me!Image10.Picture = "location of photo's" + Me![PhotoRefNo] + ".jpg"

 

[InnerSlice]

Another place that you could place the code is in the DETAIL_FORMAT section. That is how I use a text field to import the images in.

InnerSlice