I have an unbound MS Forms combo box, on form load, I
populate it by calling one of the SP from SQL server. It
all works fine except after I have add some new items for
the combo box through the 2nd form. After calling the sp
again and reload the combox, the newly added item is
there, but appears the index of it all messed up. when I
click on the new item in the box, it says the array out
of bound. I did clear the combo box before reload it. Is
there a function to reindex the item such as :
lst.index=lst.newindex
thanks