Adding a Search box (for a file)

[Roy Carlson]

I am making a database that collects biographical information about donors.
One of the pieces of information we collect is an image of the individual.
First, i tried to do an OLE object in the databse that saved the image into
the database. That was fine, however Word and Publisher use DDE and cannot
retreive this image from access.

My next approach will be to store a path and filename that Word will look at
and merge with the picture.

How do I add to the ImageName field in access (where the path/file info will
be stored) a "browse..." button that allows me to search the harddrive or
network for the file, and when I find it, will update the field with the file
location? Would I need 2 seperate fields here? One for the browse and one
for the ImageName?

thanks!