List box - How can I display one value and save another

J

Jen

If I have a table as the source of data for a list box, it has a code and a description field, how do I display just the description in the list box, but save the code to the field in my table?
 
R

Rick Brandt

Jen said:
If I have a table as the source of data for a list box, it has a code and
Click to expand...
a description field, how do I display just the description in the list box,
but save the code to the field in my table?

Set up the ListBox to have two columns. Make the column with the code the
bound column and set its width to zero.
 
Top