need help with image/attachment in access 2007 form

[jker]

1- i have PRODUCT table defined with Product_number, product_name,Product_image
2- PRODUCT_IMAGE is defined in table as ATTACHMENT


3- I have a form where the user selects from a Combo box list , the product_name
3a- forma contains 2 text boxes, for PRODUCT_NAME, PRODUCT_NUMBER and an ATTACHMENT box intended for the PRODUCT_IMAGE
4- My combox box list is based on a SELECT that contains the product_number, product_name and product_image
5- when user selects the product, my text boxes are populating with the product_number and Product_name



PROBLEM: my PRODUCT_IMAGE is not loading onto my form

question: HOW DO I POPULATE AN IMAGE/ATTACHMENT FROM A COMBOBOX LIST: (PLEASE SEE THE JPG ATTACHMENTS)

[Welshgasman]

Not recommended to have attachments, they will bloat your DB quickly if too many.
I have attached Northwind 2007 version which has those. Look to see how they do it on the Employee form.

Site is not allowing Chrome again to upload files.
I will be back with Firefox in a minute.

File is too big, even zipped, so you will have to look for it yourself.
https://www.google.com/search?q=nort...hrome&ie=UTF-8

Basically it appears to just have a bound control to the attachment field.

[moke123]

As WGasman points out, it's usually a bad idea to use the attachment fields.

Better to just store the path to the image in your database rather than the image itself.

There are a few different ways to populate the image control.
One being set the picture property of the control

Me.Image1.Picture = "C:\somefolder\somePicture.jpg"

[June7]

And ControlSource property. Review https://www.accessforums.net/showthread.php?t=73766

[jker]

If i use your suggestion, then how do i get the image to appear on the screen instead of the file and pathname?

[June7]

Did you review the thread link I posted? You set the ControlSource property of an Image control, not a textbox.

[jker]

I solved my problem:
1- added TEXT column to my table that contained the image path name for each product
2- added two fields to my form a- text filed that contains the image path name b- image control
3 bound both objects to the same CONTROLSOURCE

[Welshgasman]

I think June7 did that for you?