What's the best way to print image files in reports 1

[bhujanga]

I need to make a report that will print various information including images based on a file name that's stored in a field ([Photo]) in the table ([Inventory]). I can get it to work if I only print one record at a time by using this code:

"Reports![Inventory Info]![Image1].Picture = Photo"

in the "On Current" event, but I need to print many at once. What happens is the photo for the first record prints on all the records. How should one go about this?

Thanks

 

[dhookom]

Bind the Photo field to a control in the detail section and then try code in the On Print of the detail section like:

  Me.Image1.Picture = Me.Photo

Duane
Hook'D on Access
MS Access MVP

 

[bhujanga]

Yes, this seems to do the trick. Thank you very much.