I have connected my database "sparadespelare.mdb" with the table "tbl_sparadespelare" i have 3 colums (fields) in the tabel, and when i click on a button i want to show a new form, i have don that with from.show and then i want to have a listbox there i could click on one of the rows that the app have loaded from the database(in the listbox it should list field1), and when the user click on it it will load data from the other fields on the same row inte variables, how can i do that, i want to use the ADODB connection.
thanks