OLE object

[24sharon]

I have a table with 2 fileds
1 autonumber
2 OLE object

I have a form Unbound with 2 objects
1 listbox of all the records
2 OLEUnbound

I want on click on the list I saw the picture in the ole.

I wrote:
Me.OLEUnbound49 = Me.List5.Column(3)

and its didnt work
how can I do it?

[I know that there is the option for image and imagepath, but I want the image to be in the database (just 6)]

this is my message number 100
thanks

 

[24sharon]

there is no idea

how am I show picture (from table ole object) to unboundole by code

thanks.

 

[24sharon]

SORRY,

But last time that I try, (NO MORE!!!)

I have a list box, and OLE object, and I want to change the picture from the table.

<attach file maybe its help to understand)

 

[ssoltic]

Try this

If I understand. You want to move OLE on record what you select on listbox.

1. Change form to bound, for this, you must have Control source is table with OLE,
2. Listbox: ControlSource is empty, RowSource is table with OLE
3. on Afterupdate event of listbox put this code:

Me.RecordsetClone.Findfirst "[ID] = " & Me![ComboOrListboxName]
Me.Bookmark = Me.RecordSetClone.Bookmark

After you click on select record on listbox you got a picture on OLE box.

hope this help