Originally Posted by
mindea
Sounds to me like your Cities lookup table has two fields: an ID (autonumber) field and a city field. If you created your combo box using the combo box wizard, it asked you which value you wanted to store in your form and you must have selected the ID field. If you want to store the City name, you should change the Bound Column of the Combo box from 1 to 2.
For example if the Record Source of the combo box reads like this: SELECT [tblCities].[ID], [tblCities].[City] FROM [tblCities]; make sure the Bound Column is set to 2.