How can I display an image file that is attached to a record in a form basesd on a list box

[dljohn]

I have a DB built to track product at a customer site. When the customer enters a "tag" number into a search box on a form, information about that particular product is displayed on the form in many different text boxes. I have a table built with the "tag" number and the image file that is in a direct relationship with the main table but I cannot get the image to display when the customer selects a "tag" number in the list box. Please help. I am a new Access user and am lost!!!!

[ranman256]

Is the image saved in the table,
or is it the path to the image?

if saved in the table, select the bound image object ,and the field, then drag to form.

[dljohn]

I have one large table with all the data for devices and a separate table that links to the main with a "tag" number. The small table has two columns one with a linked tag number to the main table and an attachment column with the image file. On my form when the customer types in the "tag" number I would like for the image file attached to that "tag" number appear on the form with the rest of the information that is linked to that tag. I hope this isn't too confusing. My Access vocabulary is not that great.

[ranman256]

Attachment fields are a pain for this and are not friendly.
you should make an OLE field. This way the picture can be added /pasted directly into the field.
Then the form can read directly from it. No code needed.

[dljohn]

Can you please explain how to install an OLE field?

[dljohn]

And will this just attach the image to that particular record? When the customer searches for a new "tag" number I need the new information to refresh in the form.