I need to populate a listbox with the contents of a field in a recordset of a MDB file. When the user clicks on one of the items in the list i need all the textboxes to be populated with thier fields in the same recordset.


Example: I have 15 textboxes, each one has the info of the 15 fileds in TblLetters. Field1 holds the names of the letters so it is named "Names". Well, i want to populate a listbox with all the "Names" and then when the user clicks on a Name the 15 textboxes are filled with thier coesponding Fields.


Any help is appreciated.