Open attachment does not work

[cuddles]

I am trying to create this event to open the attachment in the database and it does not work.



Private Sub ListBox_DblClick(Cancel as Integer)
DoCmd.OpenTable "Main.Attachment", acViewNormal, acReadOnly
End Sub

[ranman256]

You have to open the recordset and the field in it is also a recordset. Then open the [FILEDATA] of the attachmt field.

http://stackoverflow.com/questions/4787149/how-to-auto-attach-images-in-access-2010-using-vba-macros