Print a different image per record

[mcaldwell]

I have created a form using an unbound object for images. It is linked to a text box that shows the path for the image. I am using the oncurrent procedure to change the image per record change.



Now I want to do something similar on the report. I want to be able to print a sepereate image per record and one record per page. Everything I try produces one image for every record instead of changing per record.

Any advice?

[thhui]

Use vba in report

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Me.Image0.Properties("Picture") = "c:\pic1.jpg"
End Sub

[mcaldwell]

Use vba in report

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
    Me.Image0.Properties("Picture") = "c:\pic1.jpg"
End Sub

Would I need to name my images pic1,pic2 or something with a counter? And then the "Picture" is the name of my unbound object?

[thhui]

image0 is the image object name you put in the report to print
just like any textbox or label you nornally put in the report.

The report should normally based on database table.
and the table should contain the field which is the path name of the image.

Finally, you should ensure the datasource of the image object equal to
the field of the path name of the printed image.

[mcaldwell]

I already have this in vba.


Private Sub GroupHeader0_Print(Cancel As Integer, PrintCount As Integer)
Me.Door_Image.Picture = Me.Image
End Sub


Door_Image is the name of the unbound control and me.image is the name of the field that contains the path to the image.

When it is like that, no image shows up at all.

[mcaldwell]

Ok so I go back into the report and the control source was blank. I simply set it to the text field containing the path and it worked. Sometimes the simple stuff is the hardest to figure out.

Thanks for all your help!!!