I have a table with product and product code. The product code is a string - not integer.

I want to populate a listbox (or combobox - dont know what is best) with the names AND codes of the products in my table so that when the user clicks on a specific productname/code I can select that specific one and display it's details.

I know how to display the name OR the code in the listbox - how do I do both!!??

while not rs.eof
lstbox.additem (rs!name)
rs.movenext
wend

How can I know what record the user selected!!?? I need to know this so that I can get that products specific info and display it.

Thank you,
T