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...

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...

I need some guidance on the listbox from a database...when I select the name from the listbox it displays fine in the textboxes...but if there is a duplicate name my search on the database gives me back the same person....anyon e have any ideas....thanks in advance........ .....Jerry