need help with COMBO BOX populating ATTACHMENT box

[jker]

in my form i have a combobox that contains TxtProductId, TxtName, TxtCost and an image (defined as attachment in the table design)

what i want to is every time i select the product from the combo box, to load the corresponding image.



this is my code:



What is happening is that the image is not being loaded into the box (defined as attachment) on my form

Private Sub CbxProductList_Click()
'************************************************* ****
'** populate screen from value selected in combox list
'************************************************* ****
TxtProductId = CbxProductList.Column(0)
TxtName = CbxProductList,column(1)
Txtcost = CbxProductList.Column(2)


TXTpRODUCTiMAGE = CbxProductList.Column(3)
end sub

[CJ_London]

What is in column 3? A path/file name? Something else?

[June7]

Load image from where - a folder location?

Can't save file into Attachment type field like that. Attachment field is a multi-value field. Review

https://stackoverflow.com/questions/...ltivalue-field

If you are trying to pull image from Attachment field for display, can't do it they way you are attempting.
Working with Attachment Fields - MS-Access Tutorial (sourcedaddy.com)

Also review https://www.accessforums.net/showthread.php?t=73766

Exactly what is this box you are trying to load an object into?

[moke123]

Most developers avoid attachment fields as they tend to bloat the size of your database.

Use a separate folder of images and either store the name of the image or store the full path to the image as text in a field.

You then use an image control on your form and set its picture property in the after update of the combobox. If you store the full path you could also bind the image control to that field in the table.

Here's an example which just stores the name of the image and a function to point to the image folder. (the folder must be in the same folder as the accdb for the function.)

[jker]

What is in column 3? A path/file name? Something else?

Column 3 is the 4th item in my select statement that i use to populate the combo box list. but i set my combox box up so that the user only sees the first 3 colomuns

[June7]

That still doesn't clarify what the 4th column contains. You state in your original post "...and an image (defined as attachment in the table design)..." which sounds like an Attachment data type field. Regardless of field type, what you tried won't work. Did any of the links or moke's db help you?

If you want to provide db for analysis, follow instructions at bottom of my post.

[moke123]

Column 3 is the 4th item in my select statement that i use to populate the combo box list.

show us the select statement.