how to open windows 'file-open' dialog

[adwaitjoshi]

I have a form which holds the pictures of participants. The pictures are linked and not embedded so as to keep the database size controlable. Is there any way where I can make a button which when clicked will open a windows default file open dialog and let the user select the file (image file) and then lik it in the respective field? I have 5 such pictures so I will have 5 buttons in all. Please help me as I am new to Access.

 

[ghudson]

If the five picture files will never change names or locations, I would use the FollowHyperlink method to open the files.

FollowHyperlink ("C:\My Documents\Picture005.jpg")

Check the help files for more options using the FollowHyperlink method.

HTH

 

[adwaitjoshi]

The pictures keep on changing for every participant.

 

[Oldsoftboss]

I refer you to this post. Has some helpful stuff.
http://www.access-programmers.co.uk/forums/showthread.php?threadid=32503