I have a form written in vb6 that the user is able to show listed items in a listbox from criteria from 4 different comboboxes. The data is being connected to an Access db. Where I am stuck at is after the search lists the data in the listbox the user is to select an item then click a command button that opens a new form, the new form has numerous textboxes, each corresponding to a field in the db, I need the textboxes to be filled with the record from the db that matches with the item that the user selected from the search screen. I am just confused if I should use an IF statement or a select query statement to fill all the listboxes. Any help would suffice. I already have the connection to the db through ADO code and I know how to fill the textboxes with the data, I just need to make sure that the textboxes are being filled with just the matching record from the search screen. Sorry this may be confusing. Any help would be great.