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?
SteveL13Asked:
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
0
 
SheilsCommented:
Try using the onchange event of the combo box
0
 
SteveL13Author Commented:
Didn't work.  I have other fields populating with the afterupdate event but the image will not.

???
0
Cloud Class® Course: MCSA MCSE Windows Server 2012

This course teaches how to install and configure Windows Server 2012 R2.  It is the first step on your path to becoming a Microsoft Certified Solutions Expert (MCSE).

 
SheilsCommented:
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)

or

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

Make sure that column 3 of the combo box has the full path of the image
0
 
SteveL13Author Commented:
1 didn't do anything.
2 gave me an error ...  Object doesn't support this property or method.
0
 
SteveL13Author Commented:
By the way... image is an attachment in the table that the query feeding the combobox uses.
0
 
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?"

--Steve
0
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.