Combo Box Contents in Report

[Bill0722]

I have a list of patient procedures. I want to report these out based on a location. In my table, I have a combo box which lets me pick from one of five locations. I can get the report I want, nicely subdivided by location, but the thing that prints on the report is the 1, 2, 3,4, or 5 which is the contents of the combo box. I want the actual alpha names of these locations to print. In the query I use, the names print properly, but in a report based on that query, I only get the location numbers.

Thanks in advance,

Bill

 

[Remou]

I think you have run into:
Did you use the dreaded anti-feature of Lookup Fields in tables?
'

http://www.mvps.org/access/lookupfields.htm

It may help to change the textbox in the report to a combobox and set the bound column width to zero.

There is a dedicated forum for reports:
Microsoft: Access Reports Forum
forum703