Updating OLE field

[Susie]

Hi,

I'm trying to update an OLE field in a table to be a linked
object. I've gotten this far:

Dim mydb As Database
Dim itemset As Recordset
Set mydb = CurrentDb
Set itemset = mydb.OpenRecordset("t_test&quot 'Create dynaset.
itemset.MoveFirst ' Find first occurrence
Do Until itemset.EOF
itemset.Edit
itemset![LinkedDocumentField] = ???
itemset.Update
itemset.MoveNext
Loop

I'm not sure what to replace ??? with to put a document there. I want to
link c:\pbs\textinvgift3.doc but don't know how to link the document in this
field instead of the text "c:\pbs\textinvgift3.doc" Any suggestions?
Thanks, Susie [sig][/sig]

 

[DougP]

I use this to load images into a form maybe it will work for you.

Me!Image14.Picture = "p:\ViewPhotos\Photos\" & Me![ID] & ".jpg"

In other words just let the object = a file on your hard drive [sig]<p>DougP, MCP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.[/sig]