I apologize for all the bothering.

I have a form that is used to enter property in , i enter, address, direction ( Like N, S, E, W, street, city, state, etc Most of these are comboboxes, and they store in the table. Then I have another form that is bound to the same table. In this form, only the Property name is a combobox; the others are textboxes that fill in the address as I select the property. Everything fills in correctly except the direction. It shows the ID instead of the text, even in the table, it shows the ID while the others show the text, the table fields are all shorttext, the lookup is set in the Combobox in the form. How can I get the direction textbox to show the text like the others?