attachment in field from VBA

[Edwinq]

hi there,
I like to fill a recordfield with type attachment from vba.
should be something like

With table
.Addnew
!field1 = something
!field2 = somethingelse
!field3 = [here i want to point to a file on disk]
.update
End with

any ideas ?
thanks in advance
edwin

 

[namliam]

It is ill advised to actually store attachements in access.

Instead store the (UNC) path of the file and use FollowHyperlink to open said file.