This is a really old thread but I'm having the same issue and am confronted with the problem you describe, i.e. if I remove the items from the rowsource then all the existing rows have gone blank. I know I can prevent people from re-using existing selections with code in Before Update as you say...