Help bringing up image in Report

[bobbobruns12]

Ok I've created this real estate database and have a search form process where by a person can type in an area and search for properties and get a list of them with details and such. However on the search details form I would like to allow people to click a command button and it automatically creates a cover page with the name of the property and an image of the property in the top right corner. The way I have set up calling up the images through the forms is instead of storing the picture in the db and slowing the whole thing down I have instead saved the image path and Access uses this to call up the picture in an unbound frame box. The code is like this

Private Sub Form_Current()
On Error Resume Next
If Not IsNull(Me![ImagePath]) Then
Me![ImageFrame].OLETypeAllowed = 1
Me![ImageFrame].SourceDoc = Me![ImagePath]
Me![ImageFrame].Action = 0

End If
End Sub

However when I try to put this code into the report on the open executor it calls up the image path fine but does not then show the image. Is there a different way I need to approach this? Thanks for your help

 

[GingerR]

Does this help?

thread703-1030523

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html

 

[bobbobruns12]

Not really I can't get that to work, any other ideas?

 

[GingerR]

What happened? It should work. Please post the code you tried. Did you put code into the report instead of on the form?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244. Basics at

http://r937.com/relational.html