Question

I have an "Image" control on a form which shows a photo.  I also have a "PictureField" text box that dictates where the photo in the "Image" control comes from.  There is some VBA in the OnCurrent event for the form which controls the two fields. Everything works as long as you type in the location of the photo in the "PictureField" text box.  My question is, is it possible to create a command button to locate and insert the address of the photo instead of having to pre-type the location in the "PictureField" text box.  This action would be similar to a "Browse" command button common in Windows software.

Answer

Many thanks for the question.  The code I use I cannot take credit for, but it can be found on the following site:

http://www.mvps.org/access/api/api0001.htm

I have found this code to be very useful and reliable.

Do you like this tip? Subscribe to my free weekly Newsletter to receive tips weekly via email. Click Here to subscribe.