My combo box is working, except I would like to change one thing.

For example, I have a combo box of city names (Dallas, Chicago, etc.), I choose one from the list. I want that name to appear in the combo box window, but I want the code for city name (001,002, etc.)to get saved to a name and address table.

And when I go to the top of the name and address table I want the city name to appear in the combo box, not the saved code for city name.

Is there an easy way to do this? Other than SEEK and look it up and translate it back to city name from the code for the city name.

Thanks for your help.