Access 2007 Attachment and Listbox Control (1 Viewer)

[anqoksan]

Hi all,
I have a simple table
ID, First Name, Attachment

What I am trying to do is create a form that would show a List of attachments using a List Box Control.

Is this even possible?? I tried searching and messing around but I can seem to get it to show the attachment list for each record.
Thanks a bunch !

 

[khawar]

Yes it is possible use attachment field as row source of listbox

 

[anqoksan]

How would I be able to do this ???

I tried linking the List box with the attachment.filename but all it does is display what ever is in it, not per record.

 

[anqoksan]

After messing around I figure I needed to make a query. Problem here is, I have no idea how I can use the query to filter out the data I want.

all it shows is

ID Attachment
1 file1.txt
1 file2.txt
2 filex.txt

Is there a way to filter this out base on the Current record I am on ??? Recored 1 is ID 1 and Record 2 is ID 2.

Any help at all is really appreciated!!!