I have a combo box that has a display member thats a normal word such as 'Name', however it's Value member is an ID ('NameID') in a database. When I run the form and say choose option 3 from a list of 4 things then decide to change the option that I've chosen to say option 2. The list changes and option 3 shows up as duplicated.
If I choose Sue, then change my mind and want to choose John the list appears as:
John disappears and Sue becomes duplicated.
Any idea how to fix this? or suggestions on what to do?