How populate image from a combobox

I have a form which has a combobox.  Also on the form is an image "field".  The after update event of the combobox isn't populating the image.  Here is my code:

Me.imgImage = Me.cboProdName.Column(3)

And here is the SQL of the combobox:

SELECT tblProductNames.ProdNameID, tblProductNames.ProdNameDesc, tblOrientations.OrientationDesc, tblProductNames.Image
FROM tblProductNames LEFT JOIN tblOrientations ON tblProductNames.OrientationID = tblOrientations.OrientationID
ORDER BY tblProductNames.ProdNameDesc;

Can this even be done?
Who is Participating?
SheilsConnect With a Mentor Commented:
It will not work if the image are saved in the table. I strongly advise against storing images in tables because it will make you database unnecessarily large and eventually slow it down significantly. You are better of storing the image in a folder and storing only the image path in the table. The one the image box set the picture type as linked
Try using the onchange event of the combo box
SteveL13Author Commented:
Didn't work.  I have other fields populating with the afterupdate event but the image will not.

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to and use offer code ‘EXPERTS’ to get 10% off your first purchase.

How are you assigning the image to the image control box.

You basically have two ways

1) In the controlsource of the image box added  cboProdName.[Column](3)


Me.imgImage.Picture = Me.cboProdName.Column(3)

Make sure that column 3 of the combo box has the full path of the image
SteveL13Author Commented:
1 didn't do anything.
2 gave me an error ...  Object doesn't support this property or method.
SteveL13Author Commented:
By the way... image is an attachment in the table that the query feeding the combobox uses.
SteveL13Author Commented:
Ok.  I understand I am going to award this topic and post another one titled, "How populate image on a form from a hyperlink on the same form?"

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.