Hello,

I am creating a Stock database, the Stock information is coming from another application being imported from Excel.

The excel spreadsheet contains your general stock information and also a path to where the image of the product also is.

I would like to get Access to read the path of the file for each record and display the image, without having to insert each image individualy.

The path of the file is in a list box which.

i have tried :

Me!ProdImage.picture = Me![List2]![ImagePath]

this does not work, the field which holds the picture is a image type not a OLE object/

Can anybody help?


thanks

The problem might be in how you're referencing your list box. If the bound column of the list box is the one containing the path, you would reference it as

Me!List2

If the path is in another column, you would reference it as

Me!List2.Column(n)

where n is one less than the actual column (this is because the first column is designated column 0, the second one is column 1, etc.).