(SOLVED) Need help on Filtering listbox

[jinro]

Hi there,
What I have is a form where you can add attachments.
What I want to do is add a listbox that displays the names of the attached attachments by Record.
So if record 1 has 0 attachments the listbox will show no names
If record 2 has 3 attachments then the listbox will display the names of those 3 attachments.
Right now my Unbound listbox that uses a query that has the attachment name and id and unuiqe ID (so it can have same type of ID Sample001, sample 001 on each attachment) shows the names of ALL attached attachments no matter what record I am on.
Any help would be really appreciated as this is the last thing holding my project to go live, i have been fighting with it for days now.


Thanks in advance for your time and help.
Attached is an example database

[amrut]

You have to requery the listbox each time you move from current record. Modify the listbox row source to include the ID field matching the one on form

SELECT test.test.FileName, test.ID FROM test WHERE (((test.ID)=[Forms]![test]![ID]));

and in the form's current event, requery the listbox.

[jinro]

BTW its on a subform where the main form and subform is displaying the custom ID at the same time (dont know if that will help at all) been trying all types of things like if id on main page = then listbox = but cant get anything to work.
Can any one lead me in a direction or another way of displaying the info I am trying?

[jinro]

posted same time as i posted the below, trying now

[jinro]

i should of used better naming conventions instead of test for mutiple. Could you please break the code down for me?
SELECT test.test.FileName, test.ID FROM test WHERE (((test.ID)=[Forms]![test]![ID]));
as in which test refers to which. I should of named testform testattach and so on so i could read better sorry, but thank you if you will do that for me.

[jinro]

NM, i figured it out just had to try it acouple of times. Thank you so much! worked

[amrut]

SELECT test(1).test(2).FileName, test(3).ID FROM test(4) WHERE (((test.ID)=[Forms]![test(5)]![ID]));

Here are all your "tests"
1.Table test
2.attachment field "test"
3.ID field in table test
4. Table test
5.Form named test
There is only one form by the name "test" in db you posted and it has a list box named "List8". Change List8 row source as I have shown and requery in current event.