John:
I concur with Marcia. I used that code to create a control for entry of city information. On 1 form I have 3 "different" addresses, mailing, billto & shipto. Each is one of these custom dropdown combo, but the underlying list is fed by a SQL statement that filters out all duplicates. A user still has to key a few keys, but it eliminates different spellings and cases. It also allows users to add a new city.
HTH
Mike