Your combo needs two columns: name,code. The boundcolumn for the combo needs to be set to 2. The ControlSource Property of the combo needs to be set to something like mytable.field. For example, in your nameaddress table, if the field name is code, the controlsource might me nameaddress.code.

Now, if the code is an integer, you need to make sure the BoundTo Property is set to .T.

HTH




>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.