I have a report that prints directly from a query. The query is run on a table and has one field that is chosen from a combo box in a form. If I run the query it shows the correct value there. However when i run the report from that query, in the spot where the combo box value should be the key index from the control source of the combo box shows up.
I have tried a number of different things to get this to work but it always returns the key index value.

You can do one of two things. Either add the lookup table to the report's query with a join on the key and select the lookup value. Or change the text control on the report to a combobox. I always use a join but I think you can do this and if you don't understand joins it might be easier for you.