The following question seems straight foreword to me and I would think that
others might find the solution useful in their applications.


Discussion: In Access 2007 when using the Attachment field you can list one
or more (image/icon/text/) files. I have an Attachment field on one of my
data entry Forms that primarily displays a JPG image. Under Properties I have
listed a path to a Default Picture (it works great).  Using the Manage
Attachments dialog box (right-clicking in the field) I can add one or more
files of my choice to any given record.  Once a file is added it overrides
the Default Picture (as expected).  If I list multiple files (in my case
JPG’s) I can view them by use of the Mini Toolbar (left-clicking in the
field) or use the Manage Attachments dialog box. With either function,
whichever JPG I select will be displayed in the field (rendered image or
icon) and will remain displayed as I work in other fields on the form.

Problem: However, when I move to another record or close the Form, the
“displayed” JPG will not be saved as the default file. When revisiting the
record, the underlying binary table will revert back and display the original
JPG (the normal order of ascending file structure; 1.jpg, 1a.jpg, 1b.jpg).
The Manage Attachments dialog box provides the user with a number of useful
options for file manipulation; however it does not provide the user an option
of selecting a specific file, if more than one is available. Perhaps
Microsoft overlooked this issue.

Dilemma: I have a report that is generated from this form that provides
selective fields of data and “hopefully” a specific image file from multiple
choices associated with a record. I really don’t want to manipulate file
structure or create a separate table to store files or use a List/Combo Box
to achieve my desired goal.      

Help: I’m new to Access and I know nothing about writing Code.  If anyone
knows a way to save a displayed file when exiting the field or at the very
least the record, I would be most appreciative of hearing from you.

Thank you in advance for your time and effort.

Carl