How to display attachment file name in a form?

[HelpMeWithAccess]

How to display attachment file name in a form? I have attachment field in my form and attached to 2 or more images. I put "Attachment.File Name" field under my attachment images. "Attachment.File Name" field displays the name of the first image of my attachment images like a "title". Whenever I click forward or backward arrow to see my attachment images, I want "Attachment.File Name" field also shows the correct name of the attachment image.



Please help me anyone out there.

[burrina]

Maybe this link will help. http://www.cimaware.com/resources/article_135.html

[ItsMe]

Doesn't the control bound to the attachment field display the name(s)?

EDIT:
Found this
http://msdn.microsoft.com/en-us/libr...ffice.15).aspx

I guess you could write some VBA to access the filename property of your Attachment Control

[HelpMeWithAccess]

For burrina,
Thanks for the site, but not reach to my target yet!

For ItsMe,
Thanks for the site, but I don't understand how to use Events or Properties.
Well, I am a starter and I need detail instruction.

With Best Regards,
me

[burrina]

I don't think you can do what you are trying to do on a form.

[HelpMeWithAccess]

Well, burrina,

I've got the answer from other forum.

- form be in Design View
- put a text box that I want to show my attachment's name
- put the value of "ControlSource" of that text box =[Attachment].[FileName]
- click Attachment,
- choose Event tab in Properties sheet,
- to put the value of "On Attachment Current", click dotted box and VBA will occur
- write Me.Recalc
- save it, close it, press F5
- done! we can test it. . .

Enjoy your form,
me

[burrina]

Good for you. Newly thing learned for me.

Thanks,