Showing an image on a form, based on selection from a combo box

[sashabaz]

I have a form which (from a combo box selection) shows information on a
project. The name of the project and its manager name are shown in the
header of the form. I want to also show the picture of the manager next to
the manager name.

I have tried to create an OLE object field in the manager table to store the
picture, and then used the image property in the form to link it to the
picture (as I did with the manager name). However, I can only get the name
of the image to appear as a link, and not the actual picture itself.

Do I need to have specific file types for the pictures??

Thanks.....

 

[Ro477]

I'm no expert, but I have something similar with one report per person, you
enter the persons name and the individual particulars come up including the
persons photo.
In the report I have an image frame which is linked to an image query which
asks for the persons name. Then it gets the file location (ie
C:\image\file\) and the file type (ie .jpg) from an image table with the
every persons imagefile name (which is his or her surname). The qry puts the
data together into a string as the name and address for the persons
imagefile, then the image frame finds and displays it.

As I said, I'm no expert but worked that one out and it works just fine.
Good luck ... Roger