I have a complaint spreadsheet in excel 2010 with a userform for storing details of complaints received. There is a search complonent. It searches any field great. Everything seems to be working fine except for 1 little problem. When I search for a record it finds the information no problem but when I save the edited record, it loses some of the data in the fields so that when I search it again it unselects some items that are in listboxes. The specific information is under animal info. Every time I resave, it loses 1 additional piece of information until all info is unselected. This sometimes happens with "Assigned to" but I can't seem to find a pattern. It used to happen to the weather items until I changed the value to true or false instead of text strings of sun, fog, rain, snow and sleet. Any ideas why this is happening? Otherwise its a great little program.

Please note that this question was posted on July 4th at this forum with no posted solutions: [URL]http://www.excelforum.com/excel-programming-vba-macros/1022450-data-disappearing-after-search-and-save.html[URL] Please post future responses at this forum.

Have also posted this on the following:
[URL]http://www.mrexcel.com/forum/excel-questions/789743-data-disappearing-after-searching-saving-excel-2010-userform.html[URL]
[URL]http://www.excelguru.ca/forums/newreply.php?do=newreply&p=13723[URL]