Select duplicate names from listbox

[jerrys57]

Hi All,
Need some help with a listbox display to textbox...After loading my listbox from the database, I need to be able to select duplicate names and display them in a textbox....it works fine on the first name but if there is a duplicate last name it still displays the first one no matter which one you click.....below is the code I am trying to use.......Pleas e any help would be appreciated.... ....

Set RS = db.OpenRecordse t("Select * from retmem where [lname] = '" & Trim(list1.list (list1.ListInde x)) & "'")

txtfirst.Text = RS("fname")
txtlast.Text = RS("lname")

[gilsygirl]

Hi All,
Need some help with a listbox display to textbox...After loading my listbox from the database, I need to be able to select duplicate names and display them in a textbox....it works fine on the first name but if there is a duplicate last name it still displays the first one no matter which one you click.....below is the code I am trying to use.......Pleas e any help would be appreciated.... ....

Set RS = db.OpenRecordse t("Select * from retmem where [lname] = '" & Trim(list1.list (list1.ListInde x)) & "'")

txtfirst.Text = RS("fname")
txtlast.Text = RS("lname")

Hi Jerry

Have u tried using the SEEK Method where u can specifically search the field from the database base on its index.

Good luck

[debasisdas]

Try to use DISTINCT or UNIQUE key word in the SQL statment to filter the duplicate values.

[jerrys57]

Hi Jerry

Have u tried using the SEEK Method where u can specifically search the field from the database base on its index.

Good luck

Thank you, but I am not sure of the code format for the seek with index, do you have an example ..thanks so much........Jer ry