Open a Single Attachment

[vito1010]

Greetings,

I have a form with an Attachment field. It will always only have one attachment for any record. How can I directly open the Attachment from the form without opening the Attachment dialog? (The Attachment will usually be a PDF, but may occasionally be a JPG).

Thanks in advance

ViTo

 

[arnelgp]

drag an attachment control on your form, set its control source to the attachment field in your table.

 

[vito1010]

I have that, but when you double click you get the Attachment dialog (where you can Add, Remove, Open, Save or Save All and that has the list of attachments, in my case only one. I want to be able to click on the attachment on the form and open the PDF from there.

 

[vito1010]

Anyone have any idea? I haven't revisited this for a while because the database was just for me, but I'm looking to give it to other people who do the same thing.
Thanks in advance.
Vito