list box - I give up

[cardgunner]

I've been searching this forum and trying every possible scenerio, and I give up. I'm sure it is something simple.

I have added a list box to an existing form. I want the list box to show me only the values where the id values are equal.

So the list box rowasource is keyqry whose fields are custid, keynm. The list box will show me only keynm. I have it locked property set to yes.

the form's record source is cstfrmqry. In that query is custid field from the custtbl.

So where do I specify to the list box only show me the records from keyqry where keyqry.custid=cstfrmqry.custid.

Like I said I'm sure this is simple but I can't figure it out.

 

[Guus2005]

Make a query that represents what you want to see.
Bound the query to the rowsource of the listbox. Enjoy!