I am going through this same thing right now. I solved the issue by using a single-click event on the item select on the listbox and transferring any other data the user wanted viewable into either labels or textboxes. It works quite well.
I suggest using a primary/unique key as your first item and set the listbox property Column Widths to 0" for the first column. (hiding the primary/unique key from view)I normally do this in case I want to lookup any other data later on using the listbox.
Use listboxname.column(0) to get the value from the first column, listboxname.column(1) from the second column, etc.
I like using label captions to display the info because the user can't change a label caption and requires less work than a textbox.
listboxname_Click() event
EX: me.labelname.caption = listboxname.Column(1)
|