I have a data imput form, how do i input the address of a picture to go along with that record, for display later in a report. I can manaully go into the table and to it but i want to do it from the form.

Use Bound Object Frame and bound it to the OLE field.
Try these codes to update the picture:

Sub UpdatePict()

With OLE1
.Class = "MSPhotoEd.3"
.OLETypeAllowed = acOLEEmbedded ' Specify type of object.
.SourceDoc = "C:\WINDOWS\0232.jpg"
.Action = acOLECreateEmbed ' Create linked object.

End With


End Sub

Thx
Rilles E.P.

Have a look at the Graphic wizard (ACCESS Powerup) at www.unsoftwareag.com. (http://www.unsoftwareag.com.)

what? where ar ethe other two replys?