Log in

View Full Version : Value form One list box to another list box



nepotist
09-24-2009, 06:01 AM
Hello I have a code that add a value in selected in one list box to another list box.. This works perfectly fine with out any errors..

The only thing that I dont understand is when I select one particular value in and add it to the other list box , the selected values is added as three items in the other list box. This happens only when this particular value is selected.

I have attached the sample database .. Please open the form Frm_MobilityProject , you can see two list boxes one available and the other is selected.. if you scroll down to the list of available you will see a item "Enhancements to County’s system of greenways, bike paths, and trails"

This Item when you try to add to the selected list will be added as three items wonder why... can some one give me a explanation why this is happening and how I can fix it.

I guess it is because this value has "," in it and it is splitting it in to three items where there is a "," am not sure but that is what I think.

Please help
Thank you

nepotist
09-24-2009, 06:04 AM
Actually when I take the "," of the database it works perfectly fine..... does any one have a explanation for it ?