Hi there,

I have 5 txtboxes that get their data from an acces database, using ado to connect. The 5 boxes refer to 5 different fields in the same table. (Table = adresses , Fields = surname, lastname, zipcode...and so on)

And I allso have a listbox with all lastnames in it.
(Table = adresses , Field = lastname)

My question is - how do I populate the 5 txtboxes with the data that belongs to the record set i choose in the listbox ?

Cheers
/ThomasF

Since you are populating 5 field values from the same table with criteria that will result to multiple recordset/result. Would you
like the last record of the last name found from your list box?
John