I am trying to create a customer list, that displays where the customer home state is. In my CustomerT, it records the state via a combobox I have on my customer form, but it records it as an id number, when i use a query or table to have as my record source, it only shows the state id number in my customer list form, not the state abrev. i have tried dlookup, and many other ways for it to translate from the id number to the text field.