This is how it works. Let's say your recordset has two fields MyCode and MyDesc. You are displaying the MyDesc on the listbox for the user but internally you need the MyCode field to store in your tables.
You will need to set the following properties for your listbox:
RowSource --> MyRecordset
ListField --> MyDesc
BoundColumn --> MyCode

When the user selects an item in your listbox this is what you get:
listbox.Text: returns the contents of MyDesc field of the selected item
listbox.BoundText: returns the contents of MyCode field of the
selected item


Hope this will answer your question.