Using Attachment fiel on a FORM

[slweiser via AccessMonster.com]

I have read and read and cannot find where this new attachement field in 2007
is really all that is is cracked up to be. I cannot make my attachment field
work.
Herre is my scenario
I have a table - Issues with a field called Attachments this is a type
attachment
I have a query that is built for my Issues Form that contains the
Attachements field.
I have the form built with many enhancements, but the Unbound attachment
control I place on the Form does not work.

I can go to the table directly and dbl click on the Attachments colum in
datasheet view and the dialog box appears and stores multiple types of
documents.

The control on my form does nothing. Should not be including it in a Query
to use in the form?? or do I need to provide a Control Source in the
properties of the attachment control? Please help - this would be so slick
if I could get this to work on a Form/query situation. Thanks.

 

[Tom van Stiphout]

On Tue, 12 May 2009 21:27:18 GMT, "slweiser via AccessMonster.com"

You should give it a ControlSource.

-Tom.
Microsoft Access MVP

 

[slweiser via AccessMonster.com]

Hi Tom, I have assigned A control source to my Attachments field in my form.
THe field comes from a query that the form is attached to.

It still does nothing, only when I place my cursor in the box, it does show
focus. ?Any other suggestions. Thank You.

Is it that simple? or is there some other code of separate table or something
that needs to be developed to make this work.

You should give it a ControlSource.

-Tom.
Microsoft Access MVP

I have read and read and cannot find where this new attachement field in 2007
is really all that is is cracked up to be. I cannot make my attachment field

[quoted text clipped - 15 lines]

properties of the attachment control? Please help - this would be so slick
if I could get this to work on a Form/query situation. Thanks.