Why does my query result differ from my report for a field?

P

Patti

Please help! I have a combo box of values in my form that feeds my table
(Let's say Table A). The list of possible values are in Table B. So, when I
enter data in my form, I see the possible list of values, select one, and can
see the value in my table and query. HOWEVER, when I run a report off my
query, I can't see this value - only a number!!!!! ARGH!
 
K

KARL DEWEY

In your query for the report add the table that is the record source for the
ComboBox. Pull down the field that has the description. Use this in the
report.
 
P

Patti

Karl,

Thanks for replying - I did try your suggestion but it's now giving me a
mismatch expression error when I try to run my report. Maybe there is
something else there that I need to do.
 
K

KARL DEWEY

Did you update the textbox in the report to use the description field as it's
record source?
 
Top