combo Box stored values

[Bentley]

Hello,

I have created a combo box in the form and have a the selected item stored into a field in a table. However, when this value is stored, it is saving as the primary key. How do I change this to show the actual value from the combo box when called up in another form or a report or even the table? I know it isn't difficult, but I am stumped. Please help Access Guru's.

Bentley

[CJ_London]

depending on the functionality of the form (i.e. user can/can't change the value) either use a combo box (with a rowsource same as you have already) or in your recordsource query link the two tables together and bring down the required value

[pbaldy]

Normally you'd save the key value; that's part of their purpose. This may be appropriate:

http://www.baldyweb.com/Autofill.htm

if you insist on saving a different value, you can change the bound column property of the combo.