Attachment help in sub-form in Access 2007

[turnertj]

I'm almost not sure if this is a query problem, or an issue with my sub-form...so please forgive me if I'm posting in the wrong place.



I have a table (Reports) that holds some descriptions of some reporting, and then an attachment field that holds the report itself. (I know I should probably be using a hyperlink, but the attachment field is more convenient). Then I have another table (PersonnelReports) that holds a Many-to-one relationship with my main table (Personnel), but calls up the data from the Reports table. I have a query that pulls the correct data out of the Reports table for each Personnel, and then I use a sub-form based on that query to display the details of the report. But the sub-form won't display the attachment field, even though it exists in the query.

I just want it to show up in my form so I can open the attachment directly in my main form for Personnel.

Any ideas?

Thanks!

[phuang]

Hi there,

I got the same problem. Every time when I tried to use a subform with an attachment field, the attachment field automatically disappeared. Does anyone knows why and how to fix this problem. Many thanks.

Kinds,

Peter