>I have a table that I want to load into a listbox with mover buttons so that the client can resequence the order of the rows. The unique key is a sequence number that the client never sees. They will only see the description in the listbox. The description is not unique. So after they move the rows around and then click on OK, how can i match up the rows in the listbox with the rows in the table so that I can rewrite the sequence number? Only the sequence number is unique and the sequence number is not in the listbox. I can not use description, which is in the listbox, since it is not unique.
>
>Can I put the sequence number in the listbox but not show it? Any ideas are appreciated.
>
>Thanks
>
>Brenda
Is this sequence number the row id? If so, I would strongly advise against changing it in this manner.
If not, make the number of columns in the rowsource 1 more than is displayed.
e.g.
with this
.AddItem("hello")
.AddListItem("world", .NewItemID, 2)
.AddListItem("1", .NewItemID, 3)
.ColumnCount = 2
endwith
Then the sequence would be
combo.List(combo.ListIndex,3)
Insanity: Doing the same thing over and over and expecting different results.