Access 2007:  I'm trying to use a pathname for an image to display on a form.  The image changes with each record.  I've added the name of the field (imagepath) to the control source for the form image control.  Using a path to an image in the PICTURE property only returns that picture for all records.  Taking the path out of the PICTURE property returns nothing.  I have displayed the imagepath on the screen to make sure that information is changing with each record, but it doesn't appear that the image control source is being used at all.  Is there something else I need to do to make this work.  I keep reading that with Access 2007 all you need to use is the image control source.  I've also tried setting the PICTURE TYPE to LINKED and EMBEDDED.  Nothing works!  If this doesn't work, is there another way to have the PICTURE Property updated each time a record is displayed?  ACCESS EXPERIENCE:  Intermediate w/ other database knowledge.
 

---

Answer from Richard Rost:

If the image is BOUND to the table (in other words, the picture is STORED in your database) then it should automatically update each time you move from record to record.

However, if you're just storing the path and filename of the image in your table (as you should be) and then loading and displaying the image as you move from record to record, you're going to need to manually load that picture each time you load a new record, using the OnCurrent event.

The best way to do this is with an Image control. Then in your OnCurrent event you can say something like:

MyImage.Picture = MyFilename

Now as you move from record to record, the image control will display whatever is stored in the MyFilename field in your table.

I cover all of this in my Microsoft Access Imaging Seminar:

http://www.599cd.com/site/courselist/seminars/access-imaging/?key=BlFAlEx