Display lookup value in form, not code.

[lggerhard]

I am working on an existing form that displays many lookup fields. For example, I have a field that asks "Did a follow-up occur?" The table stores 0 for no and 1 for yes. On my form, there is a combo box that has No, Yes in drop down. So, user can select value to change record. Great. But, what is not happening, is the display of existing records is not showing No, Yes. It shows the stored 0, 1. How do I get the displayed field to be the value, not the code?

Thanks for any help. I am an Access novice.



Laura

[June7]

Since you are not using a Yes/No type field (it's a number type field?), use a multi-column combobox, although I think you already are but maybe a review of this link will help. http://www.datapigtechnologies.com/f...combobox3.html

[lggerhard]

This was SO helpful. Thank you! It was driving me nuts and now it's working!