General information
Category:
Coding, syntax & commands
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.
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only