Image in a Report

[Kapelluschsa]

Hi everyone. I have a list box displaying multiple items, and am able to print out a report depending on which item is clicked. However, I would like to add a image to each report. In the search query that the report is generated from, the second column is a image path. I have a image frame in my report, and on format I have it following the code listed below.

Private Sub ImageFrame_Format(Cancel As Integer, FormatCount As Integer)
Me![ImageFrame].Picture = Me![searchquery]![Column(1)]
End Sub

The query that the path is stored in is called searchquery. I think i am messing up my syntax somewhere, can anyone help me out?

Thanks,
Sam

[weekend00]

you can put the textbox's name which bound to that column instead of the query name
Me![ImageFrame].Picture = Me.textboxname

[Kapelluschsa]

Hmm so now I have,

Private Sub ImageFrame_Format(Cancel As Integer, FormatCount As Integer

Me![ImageFrame].Picture = Forms![Customer Info Search]![Combo46]![Column(13)]

End Sub

The path to the picture is stored in the 14 column in Combo Box 46 on the Customer Info Search form.

Still no luck :/

[michaeljohnh]

It would be a bit mickey moused but if there are only a few images you could just hard code the image paths with VB with a Select/Case subroutine.

Have you tried using the Dlookup command? It works wonders when trying to find an associated field with a changing selection.