Hmmm. I reviewed the help file and I don't think I made my needs clear.
Lets say I have a table called Photos, with the following fields:
PhotoID - Autonumber
Taken - Date
Location - text
WhoOf - text
Desc - memo
filename - text
Pic - OLE
I can use code to populate the filenames. What I'm trying to do is link the photo with that filename to the Pic field, so that when I use a form to go through the records, the picture will be displayed. I don't want to create all those links by hand...
Also, I was hoping this could be done in A97..
--
Brian
Ozzone<oz**********@yahoo.com> June 9, 2005 1:10 pm >>>
Use the application.filesearch method and just populate a field in the
table with the filenames.
VBA help shows you an example.