attachment type field in a subform

[gutmj]

Hi All

I am using an attachment type field in one of the tables. I have a query on this table that and I would like to use it output as a source data for a subform.

Here where the issue is: it seems that I can't add one field representing the file to be visible in the form.
There is number of file metadata such as: .FileData, .FileFlags, .FileName, .FileTimeStamp, .FileType, .FileURL.

I would only like to display an icon, or a filed representing the attachment.
Appreciate any suggestions on how it could be done.

Thanks

 

[vbaInet]

Go through this thread and in some of the attachments I posted you should find a solution. Perhaps the last attachment I posted:

http://www.access-programmers.co.uk/forums/showthread.php?t=196693&page=1

 

[gutmj]

Thank you. Will take a look.