How to List attachments in MS Access 2010

[Jimultura]

Please help. Why does access make it so difficult to perform simple functions?

I have a very simple request that seems to be quite impossible to perform.


Is there a way to list attachments on a form?

I don’t just want an icon which opens up the attachments window; I want to view a list of all the stored attachments for each record on the form.

Please can anybody help?

[June7]

What is purpose for listing on form? Why not a report?

Is the form in Single view?

If you want the records on form to remain editable, use a listbox or subform with a source that is a query that expands the attachment field entries to separate rows. An attachment field is a type of multi-value field.

SELECT ID, attachmentfieldname.Name FROM tablename;

For listbox include filter criteria:
WHERE ID = Forms!formname![ID]

For a subform just set the Master/Child links properties.

Both might require code to refresh list if the attachment field is edited.