Query shows text in records, Report shows autonumber

B

bbarkman

I have a report based on a query. In the query records look fine. In the
report, there are two slots that show the autonumber instead of the text
associated with it. How do I show the text in the record? Thanks in advance.
 
S

Sprinks

Hi, b.

By any chance, is the underlying field using the Lookup feature? If so,
that's why it looks different than it really is. You may want to check out
this link:

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

Whether this is or is not the problem, in your query you will need to link
this field to its corresponding value in the lookup table, and then select
the text field from the lookup table. Save the query, open the report, and
set the control's ControlSource property to the name of the text field.

Hope that helps.
Sprinks
 
B

bbarkman

Actually, I figured it out right after I posted. I needed to change the
fields in the report to combo boxes. So I deleted the originals & then added
new ones from the field list. I had already built the fields as combo boxes
for a form. Duh... Thanks for the reply.
 
Top