Simple search problem

[spinnerkjm]

I need help with coding. .

OK the Input for what I want is :
In a drop down menu, type in a customers name. That drop down menu will have every customers name in, which I've already done.

The processing
This name is then checked against a table,

Output
Every time this name is found in a record on that table the serial number for that record should then be put in to a list box.

Following this the user can then click on any of the found serial numbers and that record will be brought up. This part I've done but it has every serial number in it and not just the customer I'm wanting to search on.

I've made a query that will find all duplicates of a name in the table I want. But it shows all duplicates. What I need is to find out how to write some statment that goes like:
For this name {in dropdown menu}
Run duplicate query
Output duplicates {in List box}

 

[spinnerkjm]

ttt

 

[k209310]

The atteatchment below may be of some use to you. I think it is a near example of what youm are looking for.

 

[spinnerkjm]

Its close and with it I might try a few things, so thanks.

Decided what I need is to know how to search a table for a name and then out put those findings in a list box. Surely that cant be to hard