How do I set a link from a saved path

[cowboy]

I have an image on my report which I want to set to a file path which is saved in a field in the source table. The field with the stored file path is called Picture1. The Image is called imgPicture1

I tried Me!imgPicture1.Picture = Me.Picture1
Me!imgPicture1.Picture = Me!Picture1
Me!imgPicture1.Picture = Picture1
(and several other variations)

None of these worked but I made a text box and set the source value to Picture1 and then used

Me!imgPicture1.Picture = Me.txtTest.Text

and it worked haha, now is there anyway to do this without having to create a text box to get the data from the record and then set the text box to not be visible? Thanks for help.

[llkhoutx]

imgPicture1 us an OOE object. It is store in an OLE object on your form, then your report references that form OLE control.

The report's OLE object record source is

Forms!YourFormName!YourFormOleObjectControlName 

[cowboy]

If my understanding is correct if I do that I have to have the image be part of the file and not just a link so the size of the file would get to large with a lot of pictures.

[llkhoutx]

No, it's just referenced.

[cowboy]

When I run the report it asks me to Enter Parameter Value for
Forms!DropInletForm!imgPicture1

When I leave it blank and press OK it says cannot find field, why am I trying to access a field in the form when the data is stored in the table?

[llkhoutx]

I don't now.

Have you researched your question in an Access reference book?

I suggest that you start a new thread with you question.